I need an API (I think) to find out the Excel version of the current user.
Based on that information I am going to create different macros.
I made a spreadsheet with a "Sort" button in Excel 2003. One of my users is
on Excel 2000, and it gives them a "variable not defined" error when trying
to run the macro. So I was going to record it in Excel 2000 also, then when
they click sort, figure which version they are running, and select the
appropriate macro.
I'm basically a noob at programming, so any help is appreciated.
Thanks