Web query

[dim4x4]

Hi,

I was just wondering whether it is possible to retrieve into Excel only one particular cell from HTML table (instead of the whole talble).

I'm using Excel 2002 (XP) and it seems only to be able to retrieve whole tables or paragraphs, but not single cells within tables.

Is there a workaround to get a number from on cell in HTML table into one Excel cell?

Thanks!

 

[Legacy 98055]

Hi
There may be a prettier way to do this.
My workaround has been to simply link to the cell affected by the data you are interested in seeing.
Import as little of the page as you can on one sheet, and link your selected cell to another sheet.
Tom

 

[dim4x4]

Thanks TsTom! I guess that's the only way.