VBA Excel: Trigger a refresh upon data change in sql connection

  • Thread starter Thread starter Gum
  • Start date Start date
G

Gum

I would like to trigger a refresh using vba excel to trigger a refresh
whenever the sql data (connected to excel) changes.
Currently I rely on the minimum refresh interval: 1 minute. There are loops
to refresh every 200 milliseconds, but the most efficient has to be whenever
the source data changes. How to get this done?
 
Worksheet_Change as I understand it, is a procedure of the Worksheet Object
whose target address is in the worksheet. That target address on the
worksheet is refreshed (1 minute min time lapse) through a process connected
to the workbookconnection and ODBCconnection. What is required is to get
the ODBCconnection to refresh each time the data in the SQL database changes.
 
Back
Top