Details of Web Query in Excel 2004

[tscrace - ExcelForums.com]

H

I gather from reading previous posts on this board that Web Query i
available in Mac Excel 2004 but that it is harder to use than th
windows version. After inspecting the MS support page on this topi
I have created a text query file and this seems to work fine, loadin
the web tables as it should

However, unless I am missing something this only seems to allow you t
load a full web page into the spreadsheet. For my purposes I onl
require one table of data from a web page

Does anybody have any ideas about how to do this or where to go fo
more info

I'm certainly looking forward to Microsoft implementing the muc
easier-to-use windows version of this function

Many thanks for your help

Tom Scrac

 

[Jim Gordon MVP]

Hi Tom,

You can limit a web query to return just the tables from a web URL using
VBA. From Excel's help:
++++
This example sets query table one to update only tables from an HTML
document.
Worksheets(1).QueryTables(1).TablesOnlyFromHTML = True
++++

But you can not be specific to just a single table on a page the way you
can in Windows Excel.

To send a request to Microsoft for this feature's functionality in Mac
Excel, please use the feedback feature on Excel's help menu.

-Jim

 

[tscrace - ExcelForums.com]

Thanks very much for your help Jim. That's pretty much what I
expected was the case. I will put in a request as you suggest.

Thanks again,

Tom