ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Web Query Refresh - Automatically Run Macro (https://www.excelbanter.com/excel-programming/277499-web-query-refresh-automatically-run-macro.html)

Donnie Stone

Web Query Refresh - Automatically Run Macro
 
I have a web query that updates every 5 minutes. I have another macro that
I want to trigger when the web query refresh completes. Can someone share
with me how to do this or point me in the right direction?

Thanks in advance for the help.

Donnie



[email protected]

Web Query Refresh - Automatically Run Macro
 
Assuming that the second macro is in the same file, after the point
where the refresh is complete in the first macro:

YourSecondMacro

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
On Fri, 19 Sep 2003 00:07:37 -0400, "Donnie Stone"
wrote:

I have a web query that updates every 5 minutes. I have another macro that
I want to trigger when the web query refresh completes. Can someone share
with me how to do this or point me in the right direction?

Thanks in advance for the help.

Donnie




All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com