I am using the MSNStockQuote Excel add-in to update a stock portfolio. Once
the add-in is installed, it can be triggered by clicking an 'Update' button
on the Excel toolbar to retrieve the current price, volume, change, etc and
make the updates to the spreadsheet.

I am also using a macro to update the end-of-day balances to another sheet
for archiving and reporting purposes.

What I want to do is add the 'Update' functionality of the MSNStockQuote
button to my macro so that I can run my updates and archiving in one step.
Is there a way to reference this button within my macro?

thanks for your help,
Tim

By the way, if you want to download the free MSNStockQuote add-in, it is
available he
http://www.microsoft.com/downloads/d...displaylang=en