View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeolson mikeolson is offline
external usenet poster
 
Posts: 43
Default url not accessible

I have a macro that imports a text file from a website, it works fine.
However, the macro contains the website where it is being hosted:
http//home.wi.rr.com/myusername/file.txt
My website: http//www.mywebsitename.com is currently hosted on the above
location. If I change the location, now my macro has the wrong url in the
code. When I use the http//www.mywebsitename.com/file.txt it does not access
the file, change to the other address it works fine. Why won't it work? If
I type both addresses in my web browser, I get the same result, why not in
the macro code?

Thank you for your help!
Mike