Run Macro on External Data Refresh
I want to run a macro after Excel automatically updates a
query from the internet.
I am using Excel 2003. The query is a refreshable web
query that is set to automatically update every minute,
without the user hitting the refresh button. The
workbook has 20 web queries in 20 different sheets, and a
master sheet that collects and summaries the data on the
20 sheets.
I would like for the macro to run after all 20 have been
updated. The refresh occurs automatically in the
background every minute, and the macro does not initiate
another refresh.
I want the software to work without the user constantly
hitting refresh.
Thanks, John Witte
|