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
Could you please consider improvement of this method?
https://msdn.microsoft.com/en-us/vba/excel-vba/articles/workbook-savecopyas-method-excel

3 comments
-
Thomas Näger commented
SaveAs method is working fine and is uploading the workbook to SP.
SaveCopyAs returns an error only. -
Anonymous commented
Sam - SaveCopyAs method does work with modern formats.
-
Sam commented
It would be great if the SaveCopyAs method worked with the modern Excel formats (.xlsx,.xlsm,.xlsb)
Currently supports only xls