Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank Page prints after last info? | Excel Discussion (Misc queries) | |||
CAPTURE INFO FROM PAGE TO PAGE | Excel Discussion (Misc queries) | |||
add new info to each page of 40 page workbook | Excel Discussion (Misc queries) | |||
need info from page one to reflect on page 2 &3 | Excel Discussion (Misc queries) | |||
Different info per printed page | Excel Discussion (Misc queries) |