using two excel workbooks at a time

[caporali]

Due to some experimental reasons I have to use an Excel workbook, A, while performing an independent data acquisition, driven by LabView 5.1, which accumulates data on another Excel workbook B. I tried to do this but, at any operation performed on A, a corresponding data loss occurred on B. How can I avoid this drawback?
With many thanks
Claudio Caporali

[Gorka Larrea]

You can't write to two workbooks at a time programatically, as you can't write two workbooks at a time physically, so you'll have to manage activeworkbook to avoid data loss. One way of doing this is checking the active workbook and wait until this finishes writing to start writing the other one.
Hope this helps