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

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?

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

Tie the refresh to the 'Worksheet_Change' procedure of the worksheet.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Gum" wrote:

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?

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

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.

"Gary Brown" wrote:

Tie the refresh to the 'Worksheet_Change' procedure of the worksheet.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Gum" wrote:

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?