SaveAs With Path Macro Help

[Mathman]

I'm have trouble getting this to work properly. Would anyone be able to help? I can't seem to get it working

Thank you!



Sub Save_Workbook()


'Save current file in current location
ThisWorkbook.Save

'Always automatically replace existing file with same name
ThisWorkbook.Save
to path C:\Users\canad\OneDrive\Documents\Testing\Master Template

"Adds Date at the front of existing file name
ThisWorkbook.SaveAs Filename:=ThisWorkbook.Path & VBA.Format(VBA.Date, "YYYY-MM-DD") & "_" & ThisWorkbook.Name
to path =H:\Testing\Master Template


"Adds Date & Time at the front of existing file name
ThisWorkbook.SaveAs Filename:=ThisWorkbook.Path & VBA.Format(VBA.DateTime, "YYYY-MM-DD HH:MM") & "_" & ThisWorkbook.Name
to path E:\Indicator Tests\-1 Testing Backup\Master Template


End Sub​

 

[JackDanIce]

You're welcome