i dont know if this is a suitable place to post this as i am using excel to fire this query with msquery, so forgive me if it is the wrong forum.

I am trying to find out when the msquery update event occurs on opening the workbook, so that i can run a piece of code before it occurs.
i have tried the activate and sheetactivate but it doesnt seem to fire before the update.



any help would be appreciated,evenif it is a big pointer to the correct place to post this

thanks