Thread: 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

It's OK .. I figured it out.

1) Switch off automatic refresh in the Query
2) Detect a change in the Criteria Cell and then force a Refresh to
the query table.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Range)
If Target.AddressLocal = "$F$11" Then
ActiveSheet.Range("C103").QueryTable.Refresh
End If
End Sub

3) Do whatever

Thanks anyway People.

Greg Glynn wrote:

> 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