I have no idea why your vis would do that, but I have developed LabVIEW to Excel vis that seem to work pretty well.
Why don't you try them and tell me how it goes?
There are 5 Sub VIs that interact with Excel and one example VI that shows one way they can be used. They're in a winzip self-extracting archive set to extract them into an 'Excel' folder on your desktop.
Use the example VI first. Type in the path of an existing workbook, or just 'Book1', the name of the sheet or just 'Sheet1',the excel cell address, and the corresponding desired cell value in the appropriate control and run the vi.
Start Excel opens and returns an automation reference to Excel. It sets the visibility of Excel to the specified Boolean state, sets the window state to Maximized,
Minimized, or Normal, and if there is no open workbook, it creates a new one.
Get List of Excel Workbooks accepts an Excel Automation Reference and returns an array of workbook names.
Set Cells in Excel Worksheet accepts an Excel Automation Number, a Workbook name, a Worksheet name, an array of Excel cell references (in A1 format), and an array of values corresponding to the cell references. After checking for the existance of the workbook and worksheet, it loops through the cell references with the 'Set Excel Cell to Value' VI.
The Set Excel Cell to value VI takes a OLE Excel Worksheet reference, a cell address and a value argument. It checks the cell address with the 'Check Excel Cell reference' VI, then sets the value of the excel cell to value.
The Check Excel Cell Reference VI checks the cell reference for validity. Cell columns may range from A to IV, and cell rows may extend from 1 to 65536. It converts A1 references to R1C1 references and returns a Boolean True if
the address is good.
