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