Data Connections - BeforeRefresh / AfterRefresh

Hi All

I usually know just enough VBA to be able to figure out what's going on from other examples
But in this case the more I read the more confused I get!!!

Can anyone tell me if it's possible to call a macro before and after a data connection is refreshed?

I have several workbooks that contain client data.
The data pulls via a SQL connection straight from the DB for our CRM software.

Each time the data is refreshed I'd like to call:
1. a macro before hand - to copy the table to another sheet
2. a macro afterwards to compare the 2 tables

I can write those macros. It's triggering them I'm having trouble with.

Even with this example on GitHub, I really don't understand how the VBA is working/being associated with my table.
I downloaded the example workbook, removed their web connection, added my own SQL connection, but nothing happens when I refresh the data

https://github.com/mcw0933/StackOver...53/tree/master

Any help would be appreciated
All the best
Vicky

Hi Vicky.

I have had some problems with refreshing data connections - but there is one application level vba line that I find invaluable: 'Application.CalculateUntilAsyncQueriesDone'. If you set up a macro to do the following:
1. Take the 'before' copy
2. Refresh all (or just the one(s) you are interested in)
3. Insert Application.CalculateUntilAsyncQueriesDone
4. Do your comparison of before v after.