Solved

Copy binary files to/from Sharepoint 2010 using VBA?

Posted on 2011-02-14
5
1,372 Views
Last Modified: 2012-06-27
I have a hybrid Sharepoint 2010/Access 2010 application that is managed/distributed via SharePoint 2010 but runs on the user's workstation (it is code-intensive and cannot run in SharePoint).

The first time a user copies the application to the workstation and executes it, a set of folders is created on the user's C: drive, into which a number of binary files need to be copied from a Sharepoint library.

Once the user's environment is set up, the product of executing the application, which is a production app that runs daily, is a set of xml and html pages that are copied to a Sharepoint library specified by the user.

 Can anybody point me to a good way to manage these copy operations within the Access app in VBA?
0
Comment
Question by:dgmoore1
  • 3
5 Comments
 
LVL 9

Expert Comment

by:Ivan Padabed
Comment Utility
check a way to use Web Services from VBA. you can do the work using _vti_bin services of the SharePoint
0
 
LVL 14

Expert Comment

by:KoenVosters
Comment Utility
I'm not at all a VBA specialist, but you can use the copy web service (copy.asmx) to upload files to SharePoint.
http://www.learningsharepoint.com/2010/09/03/upload-a-document-using-web-service-in-sharepoint-2010/
0
 

Author Comment

by:dgmoore1
Comment Utility
I just ran across this quote on StackOverFlow:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft did some magic in SharePoint to make the libraries appear as Windows network shares to the clients. So, your program can just save the file to the UNC path.

So if you are logged on as a user with permissions to the library and the URL to the library is http://SHAREPOINT/Department/Files/ (for example), you can just save or copy the PDF files to \\SHAREPOINT\Department\Files\.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

If this were true it would make life much easier, but as far as I can tell it does not work. When I try it I just get "Path not found". Does anybody know anything about this??
0
 

Accepted Solution

by:
dgmoore1 earned 0 total points
Comment Utility
Excuse me - the error I get is "Bad file name or number", not "Path not found"
0
 

Author Closing Comment

by:dgmoore1
Comment Utility
Scenario has changed; solution is no longer needed
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

763 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now