Macro to automate MSN Stock Quotes?

[Guest]

Does anyone know how to write a macro, or text within a multi task macro so
that a MSN Stock Quote can be updated through activation of that macro,
insted of clicking on the 'Update Quotes" button on the menu bar.

 

[Guest]

Paul,

I'm not 100% sure I know exactly what you are talking about. However, to
refresh external data sources (such as the data brought down with a SmartTag
MSN Quote), you would use code like;

Worksheets("Sheet1").QueryTables("ExternalData_2").Refresh

Where you would replace 'Sheet1' with your sheet name & 'ExternalData_2'
with the name you get in the 'Data Range Properties' dialog that you can get
through right clicking the data range.

Regards,

Chris.

 

[Guest]

Chris,

This meathodd works great, and it is infact what I use to refresh Query
Table stock quotes, however it does not work with an MSNStockQuote, which is
inserted into a range using the "Insert Stock Quote" button, which inserts
configurable stock quotes, from MSN Money.

Good info., but not what I need. Thanks for the try.