JoeJackson12
New Member
- Joined
- Jun 26, 2017
- Messages
- 22
Hi, I'm trying to save a sheet based on a VBA variable name and am getting the error Method 'SaveAs' of object'_Workbook' failed. Below is a snippet of the code I'm using. Everything in the code works until the SaveAs portion.
Any advice would be much appreciated, thank you!
Code:
fldrPath = "C:\Project\"
strPath = fldrPath & Range("savename").Value & ".xlsx"
ActiveWorkbook.SaveAs Filename:=strPath
Any advice would be much appreciated, thank you!