The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
2answers
61 views

Is there a way to start a SharePoint workflow from VBA code?

I created a tool in Excel VBA that generates a custom report from the data I pulled from a SharePoint list via Excel VBA code. What I want to do is change/update the "Status" field for items within ...
0
votes
1answer
100 views

Add and Update Single Item in Sharepoint List via VBA

I am trying to add and/or update single items in a SharePoint list via VBA and I found a similar question: But I have to say that I can only delete items with this code and I am not familiar with ...
1
vote
1answer
58 views

Import Sharepoint list via VBA in specific view

I am currenty trying to import a Sharepoint list in an Excel sheet via VBA and thanks to this: Import Sharepoint List into Excel Using VBA Only It is working pretty well, but if i leave the "VIEWNAME" ...
1
vote
0answers
19 views

Ms Access Linking To Sharepoint List

I have a SharePoint list with about 40,000 records * 4 columns I have linked the share point list in MS Access and attempted to run a query selecting all the records in the list into a local table to ...
1
vote
1answer
162 views

Compare Date to constant using ACE.OLEDB.12 in Excel VBA [closed]

After a lot of searching, trial and error, I finally managed to come up with an Excel VBA procedure that will return date from a SharePoint list. The query works fine if I do not qualify the Select ...
2
votes
1answer
90 views

InfoPath - Copy values from Secondary Database Connection into Main Database connection

I was Hoping that someone could help me with the problem that I have been having, I am trying to copy one repeating field from my Secondary Database Connection into my Main Database Connection. The ...
0
votes
0answers
181 views

Excel 2010 VBA to open most recent Major Version of Excel 2010 file held in Sharepoint 2010

I am using Sharepoint to enforce version control for a number of Excel Spreadheets. I want to use the major & minor versions feature to allow me and the development team to make changes against ...
0
votes
1answer
133 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 ...
1
vote
2answers
686 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 ...
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 ...
0
votes
0answers
186 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: ...
0
votes
0answers
217 views

Use xlsm Format in SharePoint 2010?

I have a excel document with xlsm format (Excel Macro-Enabled Workbook, excel document containing VBA source code) and I wonder if I can upload it into SharePoint 2010 enterprise to display the ...
1
vote
2answers
3k 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 ...
0
votes
1answer
132 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 ...
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 ...
4
votes
1answer
1k 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
1k 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
2k 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 ...