The vba tag has no wiki summary.
1
vote
2answers
30 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 ...
1
vote
1answer
362 views
Delete Excel file in SharePoint 2010 library only by using VBA
I am having a excel workbook. When a person click on the marco the files are saves to two new folders need to delete a Excel file on SharePoint.
I have tried the "Kill" function in Excel VBA, but is ...
0
votes
1answer
100 views
SharePoint 2007 VBA Find Replace
I'm trying to write a VBA macro for SharePoint Designer 2007 that will find/replace text but I cannot figure out the find/replace ojbect like I've been able to do with word. Anyone know how I could ...
-1
votes
0answers
74 views
How to Check if user is connected to Sharepoint using VBA
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 ...
3
votes
3answers
8k 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 ...
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 ...
4
votes
1answer
405 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?
0
votes
1answer
593 views
Automate exporting SharePoint list 2010 items to Excel 2010
I found this Import Sharepoint List into Excel Using VBA Only that people have been successfully using to automate the exporting SharePoint 2010 list items to Excel 2010. Currently I m also using web ...
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 ...
1
vote
2answers
1k views
Reading meta data stored in Word templates on SharePoint
I have a doc library on SharePoint for my work templates (DOTX). The doc library has a column called "Template ID". Each template has an ID stored in that column.
I want to use VBA to loop through ...
