SyncHRo beetween VB + Excel: sharing data via MS Access (ADO)?

From: CarreDas (CarreDas_at_casino.ja)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 06:40:51 -0500

state:
-------
Il have a program in Visual Basic AND Visual Basic open Excel

process:
------------
This program (VB) write data (setting, configuration etc.) into MS Access
database via ADO
User click VB button "Calculate", this command run Excel macro.

problem:
------------
This macro read data from database (via ADO).... but sometime no data is
disponible. (?)
=> last data (setting, configuration etc.) write with VB is not visible for
Excel. (?)

If I loop for read data, after N loop Excel view data.

Do you have hint for solve this problem.

Thanks