try using the workbook.open event and then saving the file to your desired
location.

--
Don Guillett
SalesAid Software

"SkylineGTR" wrote in message
oups.com...
Hi,

I would like to be able to put a button in a workbook to copy a file
from a web address to a location on my hard drive, but neither
FileCopy/CopyFile (API version)/ScriptingObject seem to be able to do
it.

I would like to do this:

CopyFile "http://a.b.c/test.xls","c:\test.xls"

Is it possible??

Cheers