web queries in excel for mac os X??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jaedend@charter.net - 28 Jul 2005 02:33 GMT

How do I create a web query in excel on the mac? I can't seem how to
create one only run an existing one. I've resorted to creating the
query on my PC and then copying the query file over to my mac - but
even doing this the mac version of excel returns the whole page, not
just the table that's selected in the query text file like when I run
it on the PC. Is this a bug?

Also, can someone please point me to a reference on the options
available in the query file and what they mean? Is there a way to
select just one cell instead of one table? Thanks....

Reply to this Message

Jim Gordon MVP - 28 Jul 2005 04:39 GMT

Hi,

I have a bunch of stuff about web queries on this page
http://www.agentjim.com/MVP/Excel/ExcelHome.htm

Some of it will seem to be out of date, but the functionality is the
same for the new versions of Excel as it is for the old versions.

One of these days I should update that section of my web site.

-Jim

Signature

Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

> How do I create a web query in excel on the mac? I can't seem how to
> create one only run an existing one. I've resorted to creating the
[quoted text clipped - 6 lines]
> available in the query file and what they mean? Is there a way to
> select just one cell instead of one table? Thanks....

Reply to this Message

jaedend@charter.net - 28 Jul 2005 04:54 GMT

Yes I saw that page when searching for info, but it doesn't really
answer my questions on how to create a web query that pulls data from
only 1 cell. NUless I overlook a link on your page, I still need a
list of all options that can be used in the web query text file as it
seems that the mac version of excel won't let you create a web query by
browsing the web page like you can on a PC.

Also, some of the pages on your website come up all garbled.

Reply to this Message

Mac Forum / Applications / Excel / July 2005

web queries in excel for mac os X??