VBA Macro error

[ariel20029]

Hi, I am trying to create a macro to saveas a file based on the information in cell C80. The macro is throwing an error on the last line saying compile error syntax error.
Can you please help.
thanks,
Sharon



Dim Path As String
Dim FileName1 As String

Path = "C:\PS CANCEL"
FileName1 = Range("C80")
ActiveWorkbook.SaveAs FileName:=Path & FileName1&".xls",FileFormat:xlNormal

 

[tygrrboi]

Have you tried it with a backslash? and an = sign after file format.

[COLOR=#333333]
ActiveWorkbook.SaveAs FileName:=Path & [/COLOR][COLOR=#ff0000]"\" &[/COLOR][COLOR=#333333] FileName1 & ".xls", FileFormat:[/COLOR][COLOR=#ff0000]= [/COLOR][COLOR=#333333]xlNormal[/COLOR]