Macro - Saveas box, specify filename, print

Microsoft Excel 2003 (full product)
November 13, 2010 at 10:11:31
Specs: Windows XP
Hi,

I have a read-only workbook that people need to fill in and save in their own my documents.

I would like to create a macro in this workbook that will open a saveas dialog box, automatically find the 'my documents' section, fill in the filename with cell G2 of the current tab, along with the date in ddmmyy format, then once the user presses the OK/Save button, it will pop up with a message saying "You have successfully saved the Deal Form for [cell G2] in My Documents, click OK to print and close", then the current tab will print and excel will close.

I would also like another macro that will do the same without the print and close bit. Just up to the point where they click to confirm save. They would choose this option if they need to continue working on the file, so it must then remain open for them so that they can continue as if they had not saved.

I have been trying to do this by myself all day. I've had enough! :)

Thanks,

Amy.


See More: Macro - Saveas box, specify filename, print

Report •

#1
November 15, 2010 at 10:30:54
re: I would also like another macro that will do the same without the print and close bit. Just up to the point where they click to confirm save.

Do you really want another macro or do you want to give the user to choice to "close and print" or "stay open and not print" from a single macro?

re: I have been trying to do this by myself all day. I've had enough! :)

Why not post what you have tried instead of us starting from scratch.

Maybe what you've tried just needs a little tweaking.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •
Related Solutions


Ask Question