To access or save to SharePoint resources, you can use the following options: Add a SharePoint account and access files using the account (Connectors) Choose File > SharePoint Server > Check In. And now it'll open Excel, open the macro enabled workbook, run the macro, save the workbook with a new name and close Excel. . To start the code, use the "Workbooks" object. Type a dot (.) after that and select the Open method from the list. Specify the file path in the first argument and make sure to enclose it in double quotation marks. In the end, run the code to open the workbook. Sub vba_open_workbook () Workbooks.Open "C:\Users\Dell\Desktop\myFile.xlsx" End Sub.