I know there have been threads on this, but I have not found any that comprehensively compare and reconcile practices for Excel 2003 and 2007. What I think I have found is:
In 2003, I can call eomonth and workday, for example functions, either unqualified, or qualified with [atpvbaen.xls].
In 2007, to call eomonth or workday I have to qualify with Application (or maybe WorksheetFunction, together or alone). I get errors when unqualified or when qualified with the file name in braces.
I have tried various combinations of the Analysis Tool Pak - VBA addin, and either reference to the Office 11 or to the Office 12 folder, to get 2007 to work like 2003 does. So far no luck.
I don't think I want to call with the Evaluate function. That seem round about.
Does that leave Application.Run, which is a bit big and awkward, as the only way to code these functions that works in both 2003 and 2007?
In 2003, I can call eomonth and workday, for example functions, either unqualified, or qualified with [atpvbaen.xls].
In 2007, to call eomonth or workday I have to qualify with Application (or maybe WorksheetFunction, together or alone). I get errors when unqualified or when qualified with the file name in braces.
I have tried various combinations of the Analysis Tool Pak - VBA addin, and either reference to the Office 11 or to the Office 12 folder, to get 2007 to work like 2003 does. So far no luck.
I don't think I want to call with the Evaluate function. That seem round about.
Does that leave Application.Run, which is a bit big and awkward, as the only way to code these functions that works in both 2003 and 2007?
