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?
 
Tie the refresh to the 'Worksheet_Change' procedure of the worksheet.
 
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.
 
You must log in or register to reply here.

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

Access Form Refresh 1
How do I save external data in Excel? 3
Refreshing NON-embedded External Data Connections 1
Refresh Bloomberg data in an excel file from a script 4
Refresh Query Table causing debug error with Background Refresh pr 2
Refresh CRM data in Excel 2007 using VBA 0
DDE automatic refresh 1
Refreshing query data via vba button 2

Back
Top