Macro options in versions of excel?

[phg]

I have a macro which was created from one recorded in one version of Excel.

However when I try to run it in a different version of Excel on another computer I find it does not run because some of the properties in the querytable and search function which were created and operate in the first version are not recognized on the second computer.

Is there a source which lists macro functions and the valid properties in various versions of Excel?

Ideally I would like to identify the Excel version and select the correct options for that version.

Thanks
Phil

 

[Jonnyu182]

What are the 2 versions of excel you are using?

 

[phg]

Sorry for the delay - I didn't have access to the second file.

The macro was written in Excel 2002 (version 10.0) and had the problem in Excel 2000 (version 9.0).

Phil

 

[RoryA]

Your best bet is to develop the macros on the oldest version they need to run on. Code is generally forward compatible (Office 2007 is a bit of an exception in some respects) but often not backward compatible.

 

[phg]

Unfortunately i don't have access to the machine with Excel 2000 to do the development work there. I was hoping someone (Microsoft?) published a list of methods with all the properties they support.

Alternately is there a way to tell Excel to act like an older version.

Phil

 

[RoryA]

No, you have to test on the earlier version. I am not aware of a single document that lists all the changed methods/arguments from version to version (though that does not mean that one does not exist)

 

[phg]

Thanks for the response. it wasn't what i was hoping for but at least I know what I have to do.

Phil