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! :)