ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Stock Quotes in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/973-stock-quotes-excel-2003-a.html)

David B. December 1st 04 09:41 PM

Stock Quotes in Excel 2003
 
I'm trying to get stock quotes to update in a single cell in an Excel 2003
worksheet. In my previous version of Excel, I used the
=MSNStockQuote.Functions.MSNStockQuote("MSFT","Las t Price","US") formula.

Now in Excel 2003, using the Smart Tag method, Microsoft Excel Help tells me
"The data that is returned may fill a large portion of your worksheet." It
certainly does. It's not what I want.

Using the Office 2003 Stock Quotes Add-in and the Research task pane, I can
"Insert Price", but I don't want to have to repeat this everytime I open the
spreadsheet.

Any information would be appreciated.


All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
ExcelBanter.com