vba to show the file save as dialog box...

M

mjschukas

vba to show the file save as dialog box..

and stop at this point and let the user pick the folder and file name and then hit OK to do the save...??

thank you...!
 
A

Andy Brown

vba to show the file save as dialog box...
and stop at this point and let the user pick the folder and file name and
Click to expand...
then hit OK to do the save...???

(Not sure how the "pick folder" bit will react but) try

Application.Dialogs(xlDialogSaveAs).Show

HTH,
Andy
 
Top