Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

Improve *Workbook.SaveCopyAs VBA method - support SharePoint / OneDrive

Currently SaveCopyAs method doesn't accept SharePoint / OneDrive path as an argument, which is confirmed on msdn forum

https://social.msdn.microsoft.com/Forums/en-US/6e6a3a94-e528-451b-866d-2b552c4e53e8/xl-vba-savecopyas-into-sharepoint-not-working-but-save-as-is-fine?forum=exceldev

Could you please consider improvement of this method?

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/workbook-savecopyas-method-excel

28 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Ivbo shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Thomas Näger commented  ·   ·  Flag as inappropriate

    SaveAs method is working fine and is uploading the workbook to SP.
    SaveCopyAs returns an error only.

  • Sam commented  ·   ·  Flag as inappropriate

    It would be great if the SaveCopyAs method worked with the modern Excel formats (.xlsx,.xlsm,.xlsb)
    Currently supports only xls

Excel for Windows (Desktop Application): Macros and Add-ins

Categories

Feedback and Knowledge Base

(thinking…)