SaveAs

[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!

 

[Javed]

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!

Sub FileSave()

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

End Sub

Pls let me know if anything more you need.

 

[Davis1309]

Nevermind....I figured it out!