First, it is very rude to "highjack" another user's Forum thread, and silly to do so for a thread that ended eight years ago. Simply start a New Message and explain what you want to do.
I'm not sure I know what you want to do, but I can give you some practical advice. When LabVIEW interacts with Excel, there should be only "one driver", and it should be LabVIEW. If you attempt (while LabVIEW has a Workbook open) to "manually" modify the Excel document, you are likely to get yourself in trouble. If you do need to do this, my advice would be to take the following steps:
- First, have LabVIEW close/save the open Excel File, and "Dispose Report" (to disconnect from Excel).
- Have Excel open the file, do whatever you need to do, then close the file.
- Have LabVIEW re-open the file and treat it as though it were brand new.
Doing it this way pretty much guarantees that the data that LabVIEW uses will remain consistent, and will be reflected in the values in the Excel Workbook when LabVIEW closes the file.
Bob Schor
P.S. -- please, do NOT reply to this post, but take my advice and start a new one.
