| 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? |
| 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 | |||
Threaded Mode
