View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default MSN Money Stock Quote Problem

Tools Macro Record New Macro (assign a shortcut key).
Data Import External Date New Web Query.
Navigate to your web site, import a sample of what you want to see in your
SS, and then go look at the code. It is very likely that the "WebTables"
have changed; the numbers of the tables are probably slightly different now
then they were when you last did the import.

Hope this helps.
Ryan---

--
RyGuy


"Mike T" wrote:

I created a spreadsheet in Excel XP for all my investments and used the MSN
Money Stock Quote add-in to update the daily activity values. I recently
upgraded to Excel 2007 and now can't get the data to appear in the cells.
Where I used to get a value, I now get #VALUE!. I have tried all the
recommendations in Microsofts Knowledge Database with no luck. Can anyone
please provide me with insight as to what has happened and a possible fix.