Thread: VBA Excel: Trigger a refresh upon data change in sql connection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gum Gum is offline
external usenet poster
  
Posts: 30
Default 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?
Reply With QuoteReply With Quote