Using VBA to rename and save workbook as cell value

[ryanerpelding]

Hello,

I am trying use VBA to rename a file as a cell value, and then save it to a folder on my desktop. The below code is what i have, but i get an the "Compile error: Invaid or unqualified reference" error. I am new to macros/vba and cant see the error. I get this error for most of the code i have pulled from the internet to do this and don't know what i am doing wrong.

Application.DisplayAlerts = False ' suppress overwrite warning message
ActiveWorkbook.SaveAs Filename:="C:\Users\Ryan\Desktop\test" & Range("Y1"), _
FileFormat:=(.xlsm), _
CreateBackup:=False
Application.DisplayAlerts = True
ActiveWorkbook.Close SaveChanges:=False

[Richard Buttrey]

Just a guess in the absence of the workbook but should there be a path separator after "test"?

[buran]

I think the problem is here

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Not 100% sure about the enumerated constant, but you could check https://msdn.microsoft.com/en-us/lib.../ff198017.aspx