I am having a problem getting web query to work with what I want
(although I expect it should work).

I need to retrieve data from the following site but web query wont do
it.

Should i be using a macro that will lead me to the site rather than
web query?

It is a webpage of data but with the extension of .xls - is this the
problem?


http://ind_as400.hub.ftn.fedex.com/BACKUP/memmon.xls

dim wb as workbook
set wb = workbooks.open("http://ind_as400.hub.ftn.fedex.com/BACKUP/memmon.xls")
'then work with wb

--
Tim Williams
Palo Alto, CA


"J.W. Aldridge" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> I am having a problem getting web query to work with what I want
> (although I expect it should work).
>
> I need to retrieve data from the following site but web query wont do
> it.
>
> Should i be using a macro that will lead me to the site rather than
> web query?
>
> It is a webpage of data but with the extension of .xls - is this the
> problem?
>
>
> http://ind_as400.hub.ftn.fedex.com/BACKUP/memmon.xls
>