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?
Bookmarks