Automatically start a macro after data refresh
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?
|