Hi,

I have a data connection in a workbook that is set to "Refresh data when opening a the file", and is not background refresh enabled.

I want to run some code after the auto refresh has taken place - on what event should I put this code?

Prior to asking this, I inserted a message box in the "Auto_Open" event, and broke the SQL associated with the data connection - when I opened the workbook, then message box popped up, which I closed, then the message to tell me the SQL was invalid. I assumed, maybe wrongly, that Auto_Open was running before the data refresh - it appears not.

Thanks

Dave