| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get a formula to automatically refresh that's a macro? | Excel Worksheet Functions | |||
| external data automatic refresh through macro/query | Excel Discussion (Misc queries) | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Data Query will not Refresh automatically | Excel Worksheet Functions | |||
| Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
Hybrid Mode
