Hi, I wrote a couple of Macros to automate certain routine tasks in my company.. I am using Excel 2003 and wrote the Macros with very limited knowledge and learned it through the internet.
Some colleagues asked me if they could use them too but it did not work on their laptops. They are using Excel 2002. Is there somewhere a list with changes of these two Excel versions?
Bye, Thx
The changes are more than likely to be around additional arguments to methods, Sort is a good example of this.
Or you have used a feature of xl2003 that is not available in xl2002, although I'm not sure there are many of these.
You could try search the xl help for 'New features'.
If the code is not too massive you could post it and explain where and what error your colleagues get.
The general rule for multi version coding is to code using the oldest version.
In the Help in the VBE there is a What's New section. I don't think it covers additional arguments to existing methods, but other than that it should be fairly comprehensive. It's probably easier just to fix the ones you have one by one. (Note: this is why you should develop on the earliest version of Excel you need to support!)
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks