Copy A File From Internet To My Desktop
I can't get Chip's file to download. chip may have access priviledges on his
file that doesn't allow copying the file. But try your code again except
remove the "http:" from the file name . I forgot when you access a file from
the web excel doesn't like the http
from
FName = "http://www.myweb.com/myfolder/TheTextFile.txt"
to
FName = "//www.myweb.com/myfolder/TheTextFile.txt"
"Edmund" wrote:
Thanks for helping but I got "Run-time error '53': File not found" at line
"Set MyFile = fsmove.getfile(FName)"
I tested with:
FName = "http://www.cpearson.com/Zips/modActivateExcel.zip"
What's wrong?
--
Edmund
(Using Excel 2003 & 2000)
|