Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh table with external data? | Links and Linking in Excel | |||
External data refresh | Excel Discussion (Misc queries) | |||
external data automatic refresh through macro/query | Excel Discussion (Misc queries) | |||
external data refresh | Excel Discussion (Misc queries) | |||
Run Macro on External Data Refresh | Excel Programming |