Trouble saving document as variable in Excel VBA

[JoeJackson12]

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.

fldrPath = "C:\Project\"
strPath = fldrPath & Range("savename").Value & ".xlsx"
ActiveWorkbook.SaveAs Filename:=strPath

Any advice would be much appreciated, thank you!

 

[MARK858]

Before asking you what your variables actually are what do you get with

fldrPath = "C:\Project\"
strPath = fldrPath & Range("savename").Value & ".xlsx"
ActiveWorkbook.SaveAs Filename:=strPath, fileformat:=51

as long as it isn't a Mac.