VBA exporting sheets

[yxz152830]

Gurus,
I tried to use saveas but seems like it really just saves the file as for example txt and then any changes that a txt file cannot have will not be saved after executing the code. So basically I have a "ghost" excel file opened for editing. Is there another way to export a sheet? Or did I use saveas incorrectly? Thanks!

 

[tonyyy]

You might consider the following...

Sub SaveSheet()
Dim Path As String
Path = "C:\Docs2021\Gigs\" 'Be sure to include the backslash (\) at the end of the path
Sheets(1).Copy
ActiveWorkbook.SaveAs Path & "NewFileName"
End Sub

Happy Holidaze!

Tony