ExcelBanter - How do you link to a MSN stock quote in Excel 2007?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do you link to a MSN stock quote in Excel 2007? (https://www.excelbanter.com/excel-worksheet-functions/140099-how-do-you-link-msn-stock-quote-excel-2007-a.html)

mman493

How do you link to a MSN stock quote in Excel 2007?

In Excel 2003, I had a list of stock quotes set up. They would automatically
update from MSN:

=MSNStockQuote.Functions.MSNStockQuote($A12,"Last Price","US")

With Excel 2007, I get #NAME? in all the cells?

All times are GMT +1. The time now is 08:31 AM.