| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically start a macro after data refresh
Good point. I hadn't even thought about it that way. I guess taking the steps
to kick off a macro versus the refresh is about the same. Thanks! "B Lynn B" wrote: Why not just write a macro to perform the manual refresh, then call whatever other procedure you want to run? i.e. Range("a1").ListObject.QueryTable.Refresh call mySub "Kurt Barr" wrote: I've set up a few data connects and I want to start up a macro each time after I've refreshed those connections. I only want the macro to run when I refresh the query and I only want to refresh manually. Is there a command to do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to automatically select the last row of data after refresh | Excel Programming | |||
| how do I get a formula to automatically refresh that's a macro? | Excel Worksheet Functions | |||
| Macro to insert this formula automatically on start up | Excel Programming | |||
| Can I automatically start a macro if the contents of a particular cell change | Excel Programming | |||
| Web Query Refresh - Automatically Run Macro | Excel Programming | |||
Threaded Mode
