Retreiving info from a web page table
Hi
Excel '97 I've written a routine that gets a table from a web page using a web query. However, I don't want the table displayed in the work book, I just need to extract a column or two of data. Is there a better/quicker way of doing this? I was wondering if it could be done using oledb/ado (of which I know very little). Any ideas would be welcome TIA Dave F. |
Retreiving info from a web page table
Hi Dave,
Here's a thread that should get you started doing this programmatically: http://groups.google.com/groups?hl=e...d.com&rnum =1 -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] Dave F wrote: Hi Excel '97 I've written a routine that gets a table from a web page using a web query. However, I don't want the table displayed in the work book, I just need to extract a column or two of data. Is there a better/quicker way of doing this? I was wondering if it could be done using oledb/ado (of which I know very little). Any ideas would be welcome TIA Dave F. |
All times are GMT +1. The time now is 08:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com