URL Web Query is editable in Excel for Windows but not Excel for Mac OSX
al Forster
Excel but not from the MAC OSX version of excel?
Jim Gordon
Although a web query can not be edited directly from the web query
properties dialog, a web query is a very simple text file that has little
more than a URL in it. You can edit these files in any text editor.
This link has more information concerning web queries:
http://www.agentjim.com/MVP/Excel/ExcelHome.htm
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
About Microsoft MVPs:
http://www.mvps.org/
Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>
----------
In article <05db01c36b7b$71f09ed0$a601...@phx.gbl>, "al Forster"
al Forster
need ODBC Drivers to use it. From What I gather, I have to pay big
bucks to buy ODBC Drivers. Is this true, or are they free from some
place that no one has informed me of? My sun is using MS Excel for
Windows 2000 and when he selects the Excel, Edit Web Query menu
selection, he actually edits or can create a new web query. He did not
have to buy any ODBC Drivers to have this capability on his window
2000 machine, why should Mac users have to pay extra for the same
capability?
Frustrated for being continuously ripped off for being a Mac OS X User
and not a Microsoft Window User.
Al Forster
>.
>
Jim Gordon
Although the terms can be confusingly similar, Web Queries have very little
to do with the program called MS Query. You do not use MS Query to make a
web query.
A web query lets you import information from an internet HTML page that
contains data tables.
MS Query is a program designed to directly connect to database tables
usually on a network to which your computer is connected. You need a
specific driver to connect to such databases as Microsoft SQL Server or
FileMaker Pro.
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
About Microsoft MVPs:
http://www.mvps.org/
Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>
----------
In article <02bf01c370e4$31fe2720$a601...@phx.gbl>, "al Forster"
al Forster
We can discuss simantics all we want, the fact of the matter is that I
took my G4 Titanium to my son's House, Plugged it into his internet
switch (Connected to a cable modem). My G4 acquired a internet IP
address and I brought up a Yahoo Stock Quotes web page to make sure
I had a connection. We both ran the same copy of an Excel Stock
Monitoring program that he developed. The program uses four URL's
Like the following and downloads 40 rows of data directly into 40 cells
of the spreadsheet. Then a macro he wrote parses out the comma
delineated data into separate cells and analyses the data.
The spread sheet works the same on both his W2K Workstation and my
G4 Titanium. The problem is, when a stock needs to be changed in the
URL Query, of the Yahoo Stock Quotes Database (embedded in this
spread sheet), my son can change the query by selecting "Get External
Data..." off the Data Menu and selecting "Edit Query..." off the
submenu. His Excel 2000 application brings up Web Query Edit Menu
that allows him to change the URL Query Line, My Excel X version for
Mac OS X brings up a message box saying:
"This external data range contains data from a Web query. Web queries
cannot be edited."
Still frustrated that Microsoft has not given use the same functionality
on both plateforms.
Al Forster
>.
>
Jim Gordon
I have a lot about how to create web queries on my web site, including a
reference to this article:
"External Data Range..." Message Clicking Use Edit Query Button to Edit a
Web Query which applies to all versions of Mac Excel 98 and later
http://support.microsoft.com/default.aspx?scid=kb;en-us;180375
It is possible to construct web queries that will prompt the user to enter
parameters that can be submitted to web servers. Examples of how to do this
are given in the article. Getting the correct syntax will probably take some
patience unless your son is an experienced HTML programmer, but the examples
are fairly straightforward.
Here is additional information
http://www.agentjim.com/MVP/Excel/ExcelHome.htm
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
About Microsoft MVPs:
http://www.mvps.org/
Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>
----------
In article <065c01c3726e$eafa3120$a301...@phx.gbl>, "al Forster"
Jim Gordon
Microsoft has updated their knowledge base article titled:
MacXL: How to Create Web Query Files
http://support.microsoft.com/default.aspx?kbid=274787
-Jim Gordon
Mac MVP
All responses should be made to this newsgroup within the same thread.
Thanks.
About Microsoft MVPs:
http://www.mvps.org/
Search for help with the free Google search Excel add-in:
<http://www.rondebruin.nl/Google.htm>
----------
In article <#wbUnxMe...@TK2MSFTNGP12.phx.gbl>, "Jim Gordon"