|
|
#18
07-22-2014, 09:08 AM
|
||||
|
||||
I've never used the GetSaveAsFileName dialogue, but that's exactly what the documentation says about it: "Displays the standard Save As dialog box and gets a file name from the user without actually saving any files."
I suppose the next step would be to take the name collected from the dialogue call—that's varResult—and use it in workbook.SaveAs. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro to save as pdf with ability to choose save as folder
|
rvessio | Word VBA | 4 | 07-25-2016 12:37 PM |
|
Outlook 2010 Macro Save as MSG, Choose Destination, set default filename
|
rslck | Outlook | 1 | 06-19-2014 10:16 AM |
|
Save As Macro that changes the file name also
|
rosscortb | Word VBA | 5 | 05-19-2014 08:40 AM |
| How do I save a Word file with a macro for distribution? | leemoreau | Word VBA | 3 | 10-04-2013 08:06 AM |
|
Word Macro: Save file as text with current file name
|
jabberwocky12 | Word VBA | 2 | 10-22-2010 12:23 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode