Saving in existing Excel, Report in/out

[Ugur]

Hi folks,

I cannot save additional data into an existing Excel file.

Purpose: I want to save data into an existing Excel file every minute. Up to now I can olny save the current 60seconds at selected postion and I am loosing all the previous data. (I am deleting the history of my text data(Excel input) in my main VI not to save every time the whole history - I am creating data up to 6 hours.)

Pls check my VI. The problem I figured out is: I cannot enter the inner True Case!!! Check if  File or Folder exist.vi does not work here properly???

(the reset of start postion does not work here??? I dont know why... with main VI including global variabel it was allright)

The local variable of my report out may also cause a problem???

thx!!

[Michael_Munroe]

You left out the extension of the file in the search, but an Excel report will have a .XLS extension.  Also you are disposing of the report every time a block is written and then attempting to append to it using the Report Out reference.

Inside your loop set a boolean when the file is opened and use it to close the old file before opening the new one.