Hello. I wanted to alter the Money Market Stock Quotes query that comes with Mac Excel 2011. Instead of retrieving the entire page, I only wanted to retrieve the Last price, so I typed in "Last" next to Selection=. The original query text is below. But when I go to run the query, it is now greyed out. Even after putting back "EntirePage" and saving, the query is still greyed out. I have tried quitting Excel and reopening it, but no luck.
If somebody would be so kind as to send me a copy of this file, perhaps pasting a new copy in would work. If you have Excel for Mac, it's in the Applications-Microsoft Office-Office-Queries folder. I would appreciate it very much.
And if you did want to take a look at the query code, it is pasted below.
WEB
1
http://moneycentral.msn.com/investor...es.asp?SYMBOL=["QUOTE","Enter stock, fund or other MSN MoneyCentral Investor symbols separated by commas."]
Selection=EntirePage
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
Bookmarks