Save As help
 

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.

Save As help
 

Hi
have a look at the GetSaveAsFilename method in the VBA help

--
Regards
Frank Kabel
Frankfurt, Germany


Brad E wrote:
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.

Save As help
 

you could assign the code

Savefile = Application.GetSaveAsFilename

ActiveWorkbook.SaveAs Savefile

HTH

Davi

--
Message posted from http://www.ExcelForum.com

Save As help
 

Hi,

FileName = Application.GetSaveAsFilename
ActiveWorkbook.SaveAs FileName


Paul


"Brad E" wrote in message
...
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.