I tried the code Bob gave me and it works except it goes to my C Drive and I want the path to be another network drive. How do I write that in.
Path = J:\ProgramOps\Exceptions Masters & Data\JPM\
Code:
Sub Saveandget()
FileName = Application.GetSaveAsFilename
MsgBox (FileName)
ThisWorkbook.saveas (FileName)
Sheets("UPDATE").Select
ActiveWindow.SelectedSheets.Delete
End Sub