| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I close the connection from excel to access after refresh? | Excel Programming | |||
| Change database connection between live and test for external data | Excel Discussion (Misc queries) | |||
| change directory for refresh data | Excel Programming | |||
| change directory for refresh data | Excel Discussion (Misc queries) | |||
| VBA code to Refresh Connection for Excel Add-in for Analysis Servi | Excel Programming | |||
Hybrid Mode
