I have searched this and other forums, my books, and the Microsoft website. I am using Microsoft Access 2002 SP1 and am trying to copy a .xls file from a internal network drive to a Sharepoint Site. I have setup "my network places" to show the applicable Sharepoint Site and Folder, and can move the file manually but when I try to use the following code, I get a "Path not found!" error.
Call FileCopy("R:\Access\Development\Gina\Automated\STARSprositUpdate\DocumentsMissingStatus.xls", "http://collaboration.organon.intra/sites/GCORM_Business_Analysis/Sample BARP Process Site/SCBM STARS Test/DocumentsMissingStatus.xls")
I have tried all different syntax and can't see to get it to work. Is this even possible, or is there a better method?
Any help would be greatly appreciated...
Thank you,
Gina
Call FileCopy("R:\Access\Development\Gina\Automated\STARSprositUpdate\DocumentsMissingStatus.xls", "http://collaboration.organon.intra/sites/GCORM_Business_Analysis/Sample BARP Process Site/SCBM STARS Test/DocumentsMissingStatus.xls")
I have tried all different syntax and can't see to get it to work. Is this even possible, or is there a better method?
Any help would be greatly appreciated...
Thank you,
Gina