Save File to SharePoint Site

MikeDBMan said:

I can download files from SharePoint through VBA. But I can't seem to save the file back to SharePoint under a different name. I get a "Run-time error '1004': Method 'SaveAs' of Object '_Workbook' failed. Does anyone have any suggestions?
My line of code is:

HTML:

ActiveWorkbook.SaveAs Filename:= _
        "https://central.xxxx.com/corp/acctg/projects/Project Accounting/Chembio/Enzymes/Project Management/201011 Billing - 2121.xlsx" _
        , FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

Click to expand...

Hi Mike,
You have hard coded your file path & file name. Without this info, excel will save where the file cam from and with the current name, so perhaps just try
ActiveWorkbook.Save
Hope that helps

Oops. I meant to upload the "variable-version" of what I was doing. In the meantime I discovered that if I leave off the FileFormat: and CreateBackup: section of code, it works just fine. Here is the code as I am now doing it:


Where TheFile is the variablized text I containing the path and file name. The file name is different from the name I downloaded from SharePoint. However it works fine as long as I don't have the additional code