macro

  • Thread starter Thread starter a_d66
  • Start date Start date
A

a_d66

hi,
how do i write a macro save the file. i mean - the macro will get t
"file" then "save as" then the user (not the macro) has to enter th
name he wants to save, and then - after klicking on the ok bottom th
macro will go on.
thank
 
Try something like the following:

Dim FName As Variant
FName = Application.GetSaveAsFilename( _
filefilter:="Excel files (*.xls),*.xls")
If FName = False Then
' user clicked cancel
Else
ThisWorkbook.SaveAs Filename:=FName
End If



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top