Tagged Questions
0
votes
0answers
10 views
Import Sharepoint (WSS3.0) List into Excel 2010 using a specific view name
I'm trying to create an Excel highlight report reading lists from a SharePoint 2007 (WSS3.0) site. This is a Excel workbook that is used as a template for different portals.
With help of this post:
...
1
vote
2answers
94 views
query a sharepoint 2010 list from excel vba to retrieve a specific record
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 ...
4
votes
1answer
464 views
Run an Excel Macros from SharePoint
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?
1
vote
3answers
8k views
Import Sharepoint List into Excel Using VBA Only
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 ...
1
vote
3answers
1k views
Can You Enhance the “Export to Spreadsheet” Action for SharePoint Lists?
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 ...
3
votes
3answers
9k views
Update List from Excel using VBA
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 ...
