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

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

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


.

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


.