2003 / 2010 Macro Compatability (Edate)

[malderon]

Hi all,

I have tried to search around for this so please forgive me if this is an issue previously covered.

At work we use Excel 2003, wheras at home I have Excel 2010. I'm having some problem using work spreadsheets at home, specifically running macros with Edate and Yearfrac in.

I think this is something to do with the fact that these functions have been moved from the analysis toolpak in 2003, (thus ticking the atpvbaen reference meant they could just be called directly as EDATE() or YEARFRAC() to built in Excel functions which means they must be called as Application.WorksheetFunction.Edate(). This may be incorrect but this is my understanding based on the fact I get Sub or Function undefined with the original code.

Is there any way to get around this without changing the code, some sort of compatability mode or something, because I don't want to have to change all the code only to have to change it all back again when I send the sheet to people at the office.



Many thanks in anticipation of your help.

 

[RoryA]

You could add a version check to your code:

If Val(application.version) < 12 then
 ' 2003 code here
Else
 ' 2007 or later code here
End If