Hey guys,
I was looking for some info about compatibility issues on running macros in 97 when the macro was written with Excel XP.
I'm having problem with users who still have 97. My macros just will not work with them. The error is related to using the Advanced Filter function.
Many thanks,
With each release of Excel,Many commands are update with enhancements that are not compatible with older versions of Excel
It is best to develop your macros on the lowest version of Excel that will run them to avoid this type of problem.
Suggest that you use a pc running Excel97 & record a macro whilst you manually do the autofilter and then replace your autofilter commands with the recorded commands.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thanks.
Yes, that's the option I've taken.
So annoying, since using the old version has made things just that little more fiddly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks