I have a code that saves a new file. (with a versioning piece as well) It works, but I would like to change it so either the new file, or the new version of the file, is .xlsx, and not .xlsm.
Please Login or Register to view this content.
I have a code that saves a new file. (with a versioning piece as well) It works, but I would like to change it so either the new file, or the new version of the file, is .xlsx, and not .xlsm.
Please Login or Register to view this content.
Given existing code, modify SaveExt to be xlsx
Note: with alerts enabled you will get a prompt when saving as .xlsx given this type does not support macros, assumed to be a deliberate action on your part.
Thanks for the help. I have changed SaveExt toAm I doing that correctly? the macro is stopping atPlease Login or Register to view this content.
So, I assume I did something wrong.Please Login or Register to view this content.
As for alerts, no, I do not want that prompt to display. I assumewill handle that?Please Login or Register to view this content.
Hi,
I figured out what the issue was. I needed to add the file format to the line where the macro was stoppingThanks for your help.Please Login or Register to view this content.
You cannot save a macro in .xlsx format, it gets removed.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks