Copy Data from Website
 

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

Copy Data from Website
 

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