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

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?
 
G

Gum

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I save external data in Excel? 3
Refresh Bloomberg data in an excel file from a script 4
Refresh CRM data in Excel 2007 using VBA 0
Refresh pivot data automation 1
vba code does not run 3
Refresh an Access Query using VBA code in Excel 6
Macro to refresh data 3
change date in a sql statement from a cell 1

Top