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.

Something like:

Sub CopyIt()
sSource = "T:Sample.xls"
sDestination = "http://intranetsite.mycompany.com/files/Sample.xls"
FileCopy sSource, sDestination
End Sub

- 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>

Any ideas?