SaveAs

  • Thread starter Thread starter Davis1309
  • Start date Start date
D

Davis1309

I need to create a macro to just open the File SaveAs, the end user can save
the file as any name or in any directory they choose. Thanks!
 
I need to create a macro to just open the File SaveAs, the end user can save
the file as any name or in any directory they choose.  Thanks!
Click to expand...

Sub FileSave()

With Application.FileDialog(msoFileDialogSaveAs)
If .Show Then .Execute
End With

End Sub

Pls let me know if anything more you need.
 
Back
Top