Excel/MSQuery - Detect when Refresh has occured
Hi Everyone,
I've got an ODBC Query which is set to automatically refresh if the
selection criteria cell (to which it is linked) changes.
Is there a way to programatically detect that the refresh has occured?
I need to update another cell after any refresh.
Perhaps I need only to detect if the selection criteria cell contents
has changed.
If anyone can suggest either solution, that would be great.
Regards
Greg Glynn
|