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.