Mike,
I'm no web expert, but server behave differently as to what/how they expect
the sent data to be.
Other difference regarding username/password, cookies etc may be involved.
A full-blown browser may well be handling these aspects for you, under the
hood, in a way that Excel cannot, or is not yet set to do so.

NickHK

"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