Automatically start a macro after data refresh

K

Kurt Barr

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?
 
B

B Lynn B

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
 
K

Kurt Barr

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top