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
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