Public Const vURL As String = “https://mysharepointsite.com/sites/” ‘<– This is from Settings URL Public Const vGUID As String = “{1d42d-367-4d9L-2tra-b18ikeuwi10}” ‘<–RegistrationImport SPList Public vConn As Object ‘Needs ActiveX Data Objects 2.8 Public vConnString As String ‘Needs ActiveX Data Objects 2.8 Public vRS As Recordset ‘Needs ActiveX Data Objects 2.8 Public vSQL As String Public vCmd […]

Public Const vURL As String = “https://mysharepointsite.com/sites/” ‘<– This is from Settings URL Public Const vGUID As String = “{1d42d-367-4d9L-2tra-b18ikeuwi10}” ‘<–RegistrationImport SPList Public vConn As Object ‘Needs ActiveX Data Objects 2.8 Public vConnString As String ‘Needs ActiveX Data Objects 2.8 Public vRS As Recordset ‘Needs ActiveX Data Objects 2.8 Public vSQL As String Public vCmd […]

Public Const vURL As String = “https://mysharepointsite.com/sites/” ‘<– This is from Settings URL Public Const vGUID As String = “{1d42d-367-4d9L-2tra-b18ikeuwi10}” ‘<–RegistrationImport SPList Public vConn As Object ‘Needs ActiveX Data Objects 2.8 Public vConnString As String ‘Needs ActiveX Data Objects 2.8 Public vRS As Recordset ‘Needs ActiveX Data Objects 2.8 Public vSQL As String Public vCmd […]

Public Const vURL As String = “https://mysharepointsite.com/sites/” ‘<– This is from Settings URL Public Const vGUID As String = “{1d42d-367-4d9L-2tra-b18ikeuwi10}” ‘<–RegistrationImport SPList Public vConn As Object ‘Needs ActiveX Data Objects 2.8 Public vConnString As String ‘Needs ActiveX Data Objects 2.8 Public vRS As Recordset ‘Needs ActiveX Data Objects 2.8 Public vSQL As String Public vCmd […]

I am attemping to export the workbook/sheet I am working on to a Sharepoint.

I’m trying to write a VBA code to copy data from a single Excel workbook and paste into an existing tab into all workbooks in the same sharepoint location with a specific naming criteria.

I have an excel file that displays a sorted table.

I have a excel sheet with list of sharepoint hyperlinks (they lead to excel/word documents).
What i want to do is a button in excel to print all documents without opening it one by one and also to able to choose numer of copies. Is it possible? I know i should use VBA for this but don’t know how to start.

I have an excel file (instance #1) with code to refresh data for any open Excel file that is separate from this one.

I’m getting an error with this code when trying to save to Sharepoint. Code is longer, but including relevant pieces.