The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
144 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" ...
0
votes
1answer
55 views

Pulling Reports from SharePoint 2007 using VBA on a Recurring Event

Is there any code that will pull in all items listed on a recurring event that has a future start date? We have created a Calendar List for each of our clients with recurring tasks that the payroll ...
0
votes
1answer
659 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 ...
0
votes
1answer
177 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 ...
0
votes
1answer
143 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
vote
0answers
54 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 ...
0
votes
0answers
17 views

Upload file to Sharepoint from outlook attachment using VBA

I am trying to automate the process to save a file (.PDF,.docx, etc) to the Sharepoint site our team is using but a file that is coming in the form as an Attachment in an Outlook form. It is a custom ...
0
votes
0answers
26 views

Request list of files and last updated file info?

I have to access to a SharePoint folder. I want to save and read updated Excel sheets periodically. I'm using WinXP with Excel 2003 (VBA) on the client side. I read a lot of stuff, but nothing ...
0
votes
0answers
52 views

Exporting MS Access Report to Sharepoint Site

I have an MS Access database that contains reports that I would like to export as pdfs and automatically upload to a SharePoint site. Currently, I'm exporting the reports manually and manually ...
0
votes
0answers
51 views

RTE 2501 when using OutputTo to save to a SharePoint 2010 document library, but works fine when saving to local HDD

I have an MS Access 2010 databases that creates a PDF and then saves the file to a SharePoint 2010 document library. This had been working fine for a couple of years, but now I am getting a 2501 ...
0
votes
0answers
215 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 ...