I have created a SharePoint 2010 list with 2 relevant columns: - Identification Key - Version Number I want to be able to query this SharePoint list from Excel VBA - passing the Identification Key to ...
I have a Microsoft Access 2010 database published to Sharepoint 2010. I am able to use an ADO connection to connect to the database from Excel. The Excel file is not published to Sharepoint, just ...
I was wondering if it's possible to initiate Excel macros (Excel file is located on a network drive) from SharePoint? Are there any add-in features within SharePoint that can communicate with macros?
In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
Do you know of any resources/solutions to enhance the List’s “Export to Spreadsheet” function so that, once the data is opened in Excel, something would trigger VBA Macro(s) to start formatting the ...
I'm in the enviable position of having to support a client who wants to maintain and manipulate a complicated business spreadsheet in Excel, and then push a selection of that data to a list in ...