Macro to automate MSN Stock Quotes?
 

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.

Macro to automate MSN Stock Quotes?
 

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.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Paul" wrote:

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.

Macro to automate MSN Stock Quotes?
 

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.




"Chris Marlow" wrote:

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.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Paul" wrote:

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.