using VBA to Save with date to HTTP

[Jeff up North]

Hello All,

I am having trouble getting the following code to work with date, if I remove the format date it works great add the date code and it does not work, I do not know if it makes a differance but the is the second save function, please help

here is my code

ActiveWorkbook.SaveAs "http://ian-corp/sites/ConstructionManagement/Inspectors%20Report%20Master%20Weekly/2013%20CCONSTRUCTIN%20BACKUP/2013%20CONSTRUCTION%20TRACKER.xls" & Format$(Date, "MMDDYYYY"), FileFormat:=52

Thanks in advance, Jeff

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[Jeff up North]

Arlu1201,

I had been working on this for to long took a break and came back and it did not take long as I know I was close here is the working code

ActiveWorkbook.SaveAs "http://ian-corp/sites/ConstructionManagement/Inspectors%20Report%20Master%20Weekly/2013%20CCONSTRUCTIN%20BACKUP/2013%20CONSTRUCTION%20TRACKER%20BACKUP%20FILE " & Format(Now, "MM-DD-YYYY hh-mm-ss AMPM") & ".xls", FileFormat:=52