A
al Forster
Why is a URL Web Query editable from the Windows 2000 version of MS
Excel, but not from the MAC OSX version of excel?
My son and I both ran the same copy of an Excel Stock
Monitoring spreadsheet that he developed. The program uses four
URL's and automatically downloads 40 rows (representing 40 ticker
symbols) of Yahoo stock 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."
Frustrated that Microsoft has not given use the same functionality
on both plateforms.
Al Forster
Excel, but not from the MAC OSX version of excel?
My son and I both ran the same copy of an Excel Stock
Monitoring spreadsheet that he developed. The program uses four
URL's and automatically downloads 40 rows (representing 40 ticker
symbols) of Yahoo stock 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."
Frustrated that Microsoft has not given use the same functionality
on both plateforms.
Al Forster