Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Show documents in sharepoint document library and select one using vba in MS Access

Posted on 2013-05-13
2
Medium Priority
?
732 Views
Last Modified: 2013-06-03
VBA code to list documents in Sharepoint document Library and allow the user to select file. Then copy to local PC.  The documenst will be Excel books.
0
Comment
Question by:newholyman
2 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 1500 total points
ID: 39164176
Hi,
which Access and which SharePoint version?
Your question consists of three parts:
1. Get the list of documents
2. Build the UI for this list
3. Download the files
Part one should be doable by building a SOAP web service request to the list web service, calling the GetListItems method.
As I am no pro in Access I can not help directly on the other two topics.
HTH
Rainer
0
 

Author Comment

by:newholyman
ID: 39164301
Microsoft Access 2010 and sharepoint 2010.  I have develope an application that Filecopy a file from sharepoint to MY Documnet folder.  But have not found the code to allow the user browse a share document library and choose a file then copy the chosen file My Document folder.  Than you for your help.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question