Hey guys

Hopefully someone can help, I had this code which was uploading the file to a sharepoint sucessfully, I was trying to add a date to the end of the sharepoint with something like format (now(), "mm-dd-yyyy", but I could only get the SP to save it as either the date name, or the file name, but wouldnt save as "current name" & "" & mmddyyy


Sub loadtosp()
Dim thefile, thepath As String
Let thepath = "http://omt111.sharepoints.com/teams/folder/here"
Let thefile = "sharepointupload.xlsm"
ActiveWorkbook.SaveAs Filename:=thepath & thefile, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=True
End Sub


and now the code keeps debugging, and I am not sure why. can anyone help?

thank you!