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

[Guest]

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...!

 

[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

then hit OK to do the save...???

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

Application.Dialogs(xlDialogSaveAs).Show

HTH,
Andy

 

[Ken Macksey]

try

Excel.Application.Dialogs(xlDialogSaveAs).Show


HTH

Ken