The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
3answers
14k 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
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 ...
3
votes
3answers
13k 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 ...
0
votes
1answer
131 views

Uploading a document to a SP 2010 server via VB6

I'm currently trying to upload a file to a SharePoint 2010 server from within a VB6 application. Unfortunately I can't use any .NET or other additional libraries. I've read a couple of suggestions ...