Run Macro on External Data Refresh

  • Thread starter Thread starter John Witte
  • Start date Start date
J

John Witte

I want to run a macro after Excel automatically updates a
query from the internet. I've tried the suggestions from
earlier posts i.e. running macro on change of cell, and
the macro only runs if user keys change.

Any thoughts. Thanks John Witte
 
Tom,
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
 
Back
Top