Hi Everyone,

I'm trying to write a simple VBA macro to Save a Workbook with today's date to a folder on a shared network drive. The below is not working as I get a Compile Error that states "Wrong Number of Arguments or invalid property assignment":


Sub Save()
'
' Save Macro
'

'
ActiveWorkbook.SaveAs ("\\[Network Drive]\[Folder]\[Sub Folder]\Daily SPM IL Tracker" & Format(Now(), "MM.DD.YYYY") & ".xlsb")

End Sub


Any ideas?