| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you Copy a Chart from a Website into Excel? | Excel Programming | |||
| copy website to worksheet | Excel Programming | |||
| Macro to Copy data from e-mail and paste it into a field on a website | Excel Programming | |||
| Copy from website to Excel | Excel Programming | |||
| How Do I Copy a Website Page To A Sheet? | Excel Programming | |||
Linear Mode
