Save workbook on a sharepoint site using vba

[jonathan12]

I am using excel 2003 and getting a Runtime 1004 error, Method Saveas object '_workbook' failed.

ActiveWorkbook.SaveAs Filename:= _
"http://sp3/sites/Rke-IT/TE/Shared Documents/Excel Mech Rater_Prioritization.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=True, CreateBackup:=False, ConflictResolution:=xlLocalSessionChanges

I can save manually.

I have tried removing everything excel the path and it still fails.

[dpbruck]

Saw one source suggest removing the "http:" from the filename. Didn't work for me, maybe because mine is HTTPS....

[dpbruck]

OK...Now I have mine working. Like I said, it's a secured site, so I'll do a bit of hiding in the code.
Here are some factors that may be pertinent.

• Logged onto site
  Added the "HTTPS:"
  Removed the "Forms/AllItems.aspx" from the end of the address
  Replaced spaces with "%20"

Please Login or Register  to view this content.