Results 1 to 1 of 1
Thread: FileCopy to web folder (xl2000)
2005-09-28, 21:39 #1
- Join Date
- Jul 2002
- Sun Prairie, WI, USA
- Thanked 0 Times in 0 Posts
FileCopy to web folder (xl2000)
Wondering if anyone has ever tried (and succeeded!) to use the FileCopy statement in Excel VBA to copy a file from a drive to a Web Folder.
sSource = "T:Sample.xls"
sDestination = "http://intranetsite.mycompany.com/files/Sample.xls"
FileCopy sSource, sDestination
- I can map the web folder to a Network Place (via Add Network Places),
- I can manually copy the file in Explorer,
- But I can't get the syntax right to make the copy work in VBA.
<img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>