Expected: list separator or ) Error

[Legacy 319654]

What am I missing? I have a macro workbook trying to save as .xlsx workbook in folder xlsx_xlsx.

I get compile error: Expected: list separator or )

Sub ssFile()

ActiveWorkbook.SaveAs ("C:\Users\pnix4\Desktop\xlsm_xlsx\HireTerm  “ & Format(Now(), “DD-MMM-YYYY”) & “.xlsx”)


End Sub

Thanks

 

[cerfani]

ah yes Alerts, sorry, my mind went blank and called them notification but you got the right idea regardless. No prob, happy to help.

Also I see it a lot but you dont have to reset DisplayAlerts...

https://msdn.microsoft.com/en-us/library/office/ff839782.aspx

If you set this property to False, Microsoft Excel sets this property to True when the code is finished, unless you are running cross-process code.

[COLOR=#333333]Sub ssFile()[/COLOR]
[COLOR=#333333]    Application.DisplayAlerts = False[/COLOR]
[COLOR=#333333]    ActiveWorkbook.SaveAs "C:\Users\pnix4\Desktop\jjjjjjjHireTerm " & Format(Now(), "DD-MMM-YYYY"), xlOpenXMLWorkbook[/COLOR]
[COLOR=#333333]End Sub[/COLOR]