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!

On Jun 2, 6:24*pm, Davis1309
wrote:
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.

Nevermind....I figured it out!

"Davis1309" wrote:

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!