saving

[D]

What would be a sub from a userform by clicking on a button to open the
"Save As" window?
Thanks

 

[kiat]

application.dialogs(xldialogsaveas).show

 

[igor]

ActiveWorkbook.SaveAs ("c:\")

 

[Paul M]

So Many ways to skin a Cat:

Application.GetSaveAsFilename

Read the help information for filtering the display files.