View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Witte John Witte is offline
external usenet poster
 
Posts: 3
Default 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