Thread: Save As help
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Paulw2k Paulw2k is offline
external usenet poster
 
Posts: 36
Default 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.