Hard to tell without testing the actual but
Have you tried it with just the website?

--
Don Guillett
SalesAid Software

"mikeolson" wrote in message
...
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