Save As help

B

Brad E

I have a macro assigned to a button. With this macro, I
want to bring up the "Save As" dialog box just as if the
user was to go to File > Save As.

Is there a way to do this?
Thanks, Brad E.
 
D

DSC

you could assign the code

Savefile = Application.GetSaveAsFilename

ActiveWorkbook.SaveAs Savefile

HTH

Davi
 
P

Paulw2k

Hi,

FileName = Application.GetSaveAsFilename
ActiveWorkbook.SaveAs FileName


Paul
 
Top