LookingForHazyDays
New Member
- Joined
- Jan 26, 2022
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
I have an Excel file which currently uses vba to delete stuff and then save what's left as a new file with the new filename written into the macro. Like this:
ActiveWorkbook.SaveAs Filename:="x:\Folder Name\Client1_Client2_ClientCopy.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Application.DisplayAlerts = False
End Sub
Instead, what want the vba to do is save the file as the current file name with "Client Copy" on the end.
How do I do this please?
ActiveWorkbook.SaveAs Filename:="x:\Folder Name\Client1_Client2_ClientCopy.xlsm", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Application.DisplayAlerts = False
End Sub
Instead, what want the vba to do is save the file as the current file name with "Client Copy" on the end.
How do I do this please?