I'm having a little problem with a 'save as' macro. I don't know who is going to use the spreadsheet I'm working on, so I'd like to add a button that lets users save as a new file with a different name, but which opens a dialogue box to let them choose where (because I don't know who will be using it, so I can't specify the file path).
However, I would like to a) suggest what they call the file based on some information they entered in the spreadsheet, and b) specify that the spreadsheet be saved as a macro-enabled file, because I know that if I don't I'll be getting a hundred emails a day asking why such-and-such doesn't work on their spreadsheet all of a sudden.
This is the code I have, I thought adding 'xlsm' to the file name would do it, but that doesn't work (although the rest of it does, it brings up a save as dialogue box with the correct suggested filename), and I tried adding a 'file format' argument, but I must be getting the syntax wrong.
This is the code for my macro:
Please could someone point out what I'm doing wrong? Thank you.Please Login or Register to view this content.
Bookmarks