View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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)