| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save As Macro options
Hi
Try this. Do fName = Application.GetSaveAsFilename Loop Until fName < False And fName < """" ThisWorkbook.SaveAs fName Regards, Per "Danielle0904" skrev i meddelelsen ... I want to do a save as macro that will prompt the user to designate the file location and enter their own personalized file name. Then once they click okay to save, I want to be able to complete the macro by emailing it out. Help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
| Save options | Excel Discussion (Misc queries) | |||
| Save options | New Users to Excel | |||
| How do I set Save Options? | Excel Discussion (Misc queries) | |||
| How can I save an other route in my Tools bar-options-save? IT | Excel Discussion (Misc queries) | |||
Threaded Mode
