I need a macro that can copy the current date into cell A1. It should then bring up a Save As dialog box with a folder's file path location (bar along the top) copied from the text in cell A2. The Save As box should also have the desired file name read in from cell A3.
Also, it would be helpful if the current date could not be copied to cell A1 if the user selects "cancel" in the Save As box. However, the main thing is bringing the file path and file name into the dialog box.
Currently, I am able to bring in the current date using the following code but am having trouble with the Save As component.
Any thoughts?
Bookmarks