EMCIT
asked on
Copy a File From SharePoint
I am using a MS Access application that I need to copy a file from SharePoint and paste a copy to the local machine but I can't get the right format for the path. Any assistance is appreciated.
You may want to use the explorer view to open the document library as a normal file share. And then copy the file as if you are copying a normal file in windows and then paste it to your local drive.
Please note, opening the SharePoint document library will take few seconds and the copy paste will also take few seconds more as compared to normal copy paste operations in windows.
Let me know how it goes.
Please note, opening the SharePoint document library will take few seconds and the copy paste will also take few seconds more as compared to normal copy paste operations in windows.
Let me know how it goes.
ASKER
This is the code I am using in the On Load Event of the form "LaunchForm":
Me.TheUser = Environ("username")
Dim sDest As String
Dim sSource As String
sSource = "http:\\SPAddress.SPAddress.com\HomePage\SiteName\Documents\Launch.accdb"
sDest = "C:\Documents and Settings\" & [Forms]![LaunchForm]![TheU ser] & "\Desktop\NewFileName.mdb"
FileCopy sSource, sDest
Dim appAccess As Access.Application
Set appAccess = CreateObject("Access.Appli cation")
appAccess.OpenCurrentDatab ase "C:\Documents and Settings\" & [Forms]![LaunchForm]![TheU ser] & "\Desktop\NewFileName.mdb"
The problem seems to be with the "http" address. I get a Run-Time Error '52'. Bad file name or number at the FileCopy sSource line. The sSource file, stored in SP, is the file I need to make a copy of.
Me.TheUser = Environ("username")
Dim sDest As String
Dim sSource As String
sSource = "http:\\SPAddress.SPAddress.com\HomePage\SiteName\Documents\Launch.accdb"
sDest = "C:\Documents and Settings\" & [Forms]![LaunchForm]![TheU
FileCopy sSource, sDest
Dim appAccess As Access.Application
Set appAccess = CreateObject("Access.Appli
appAccess.OpenCurrentDatab
The problem seems to be with the "http" address. I get a Run-Time Error '52'. Bad file name or number at the FileCopy sSource line. The sSource file, stored in SP, is the file I need to make a copy of.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. Works perfectly!
Find the file in SharePoint, right click on the file, click Copy Link Address. Paste into a document. That's the document's path (URL).
Regards,
Bill