Hello all,
I have a worksheet that has a connection to an Access database query. I unfortunately am not the only person who uses this file and who may refresh the connection to get the most up to date data. Is there an event handler of some type that can catch a refresh of a data connection? I would like to do a few things with the data (in vba) after it is refreshed and I don't want to assume the other people would remember to do these things.
Thanks,
Audioa84
I have a worksheet that has a connection to an Access database query. I unfortunately am not the only person who uses this file and who may refresh the connection to get the most up to date data. Is there an event handler of some type that can catch a refresh of a data connection? I would like to do a few things with the data (in vba) after it is refreshed and I don't want to assume the other people would remember to do these things.
Thanks,
Audioa84