Copy local file to a sharepoint Folder? (1 Viewer)

Number11

Member
Local time
Today, 13:15
Joined
Jan 29, 2020
Messages
502
Hello,

I need to copy a report that is generated from MS Access from c:\ drive to a sharepoint folder is this possible
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 07:15
Joined
Feb 28, 2001
Messages
23,162
I would start by doing a DoCmd.OutputTo of the report to a specified local file. Then you perhaps could use FSO to copy the file.



The video is done from Excel but uses VBA to do it so the basic code would work from Access's VBA.

Finally, when finished with the copy operation, dispose of the local copy with the VBA "Kill" verb.
 

Number11

Member
Local time
Today, 13:15
Joined
Jan 29, 2020
Messages
502
thanks so i have my excel report created in a local found so just need to now have the code coy the file to a sharepoint folder
 

Gasman

Enthusiastic Amateur
Local time
Today, 13:15
Joined
Sep 21, 2011
Messages
10,853
W
thanks so i have my excel report created in a local found so just need to now have the code coy the file to a sharepoint folder
Why not watch the video and just do it directly?
 

Users who are viewing this thread

Top Bottom