I need to create a one click button to do the following.
Two sheets (worksheet 1 and worksheet 2) deleted from the workbook "file A"
Prompt a save as for "file A mm-dd-yy" for todays date. (needs to have no password and file A has one, no read only prompt, and no backup needed)
Attach the new file (file A mm-dd-yy) into an email.
I have listed the code I have at this point, although, I am having trouble with the save as portion.
I have used application.getsaveasfilename before I used the below, and though it allowed me to input the file name I needed, it didn't save permanently.
Also is there a way to do this without having to type in the file name at each save, just save as the file name with today's date in mm-dd-yy format?
I just can't get it. Can you please help?
Bookmarks