If I opened the excel file in a different excel version, will I have the same macros I am using?
If I opened the excel file in a different excel version, will I have the same macros I am using?
You will have the same macros, but whether they work depends on whether the macro uses anything that the version in question supports or not.
Yes and no
The macros will (probably) be the same but MS is adding new features and functions all the time
So if you write a macro that uses features introduced with the latest version, it most likely won't work with an older version, but older version macros should work with a new version
Same for writing a 64 bit macro and then using it with 32 bit version of office
Conditional compile might help
https://stackoverflow.com/questions/...-excel-version
https://learn.microsoft.com/en-us/of...al-compilation
---------------------------------------------------------------------------------------------------------------------
Paul
Remember: Tell us WHAT you want to do, not HOW you think you want to do it
1. Use [CODE] ....[/CODE ] Tags for readability
[CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
2. Upload an example
Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
3. Mark the thread as [Solved] when you have an answer
Thread Tools (on the top right corner, above the first message)
4. Read the Forum FAQ, especially the part about cross-posting in other forums
http://www.vbaexpress.com/forum/faq...._new_faq_item3