View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
news.stofanet.dk news.stofanet.dk is offline
external usenet poster
 
Posts: 2
Default Make onTimer wait until Excel finish database request?

Hi all,

I have a spreadsheet that:
1) Every minute connect to a database importing data to Excel (no vba)
2) Every half hour save the spreadsheet to disk (vba onTimer event)

Sometimes the two "timers" collide bringing up a popup, asking if the user
will save now, or wait for the update. It stops everything.

Is there a way to avoid the popup? - It does not matter if the current
database update or save is canceled.

--
Hans