VBA trigger action after data from other sources are refreshed

Hi guys,

is there a way to run a procedure after data from other sources (MS Query/DB) are refreshed?
I set the property for this connection to "Refresh data when opening the file".

I want to copy some part of this data to another worksheet, so I have added code to the ThisWorkbook object.
Procedure is fired after opening the file, but before the data are retrieved from DB. So it copies nothing...

Thanks

Please Login or Register  to view this content.

Thanks, did not not this can be done.