Interesting Query Problem

[SamSmithNZ]

I'm trying to run a saved query, that references a website and
extracts relavant data from the html page in Office 2001. I've edited
a saved query like MS told me to, and saved the query as a new query.

When I click "Run Saved Query" from the "Get External Data" menu
everything works fine, but when I try and record this as a macro and
play it I get the message:

Run Time Error 1004

Unable to open [http://www.myurl.com/Page.htm]. Cannot download the
information as requested.

Why is it that the query works by itself, but it won't work from a
macro???

Any insight would be appreciated.

Thanks

Sam Smith