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'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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macro on External Data Refresh
What version of Excel.
How is the query run - is it a querytable. Instantiate events for the table and use the AfterRefresh event. http://support.microsoft.com/default...03&Product=xlw XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events http://support.microsoft.com/default...35&Product=xlw XL97: How to Use the Query Before and AfterRefresh Events -- Regards, Tom Ogilvy "John Witte" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macro on External Data Refresh
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 -----Original Message----- What version of Excel. How is the query run - is it a querytable. Instantiate events for the table and use the AfterRefresh event. http://support.microsoft.com/default.aspx?scid=kb;en- us;287103&Product=xlw XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events http://support.microsoft.com/default.aspx?scid=kb;en- us;182735&Product=xlw XL97: How to Use the Query Before and AfterRefresh Events -- Regards, Tom Ogilvy "John Witte" wrote in message ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Macro on External Data Refresh
did you test to see if the event fires after the refresh?
-- Regards, Tom Ogilvy "John Witte" wrote in message ... 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 -----Original Message----- What version of Excel. How is the query run - is it a querytable. Instantiate events for the table and use the AfterRefresh event. http://support.microsoft.com/default.aspx?scid=kb;en- us;287103&Product=xlw XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events http://support.microsoft.com/default.aspx?scid=kb;en- us;182735&Product=xlw XL97: How to Use the Query Before and AfterRefresh Events -- Regards, Tom Ogilvy "John Witte" wrote in message ... 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 . |
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) | |||
Automatic refresh of external data | Excel Discussion (Misc queries) | |||
external data refresh | Excel Discussion (Misc queries) |