Excel Specific

[Yarmouth]

Hi, everyone! 

I meet a strange problem. Look at the block. If I choose 'no change' instead of 'minimized', then in the 'Array', between the elements from ten to nineteen(index) will be zero. But 'minimized' will solve the problem.Another way to solve it is not good but effective: not to close the reference.

[RavensFan]

Elements 10-19 are coming from whatever is the second file in your filepath array.  Perhaps you have a problem with that file trying to open.  Try putting indicators on those error wires to see if there are any errors opening the file.

[Yarmouth]

The three files are produced by the same procedure and the different results seem to depend on the parameters wired to the 'New Report.vi' as I have mentioned before. Now I just find the different results depend on the different running time. So strange! Is there

anything wrong with the threads? 

[RavensFan]

It's hard to say what is going on.  Are you sure all of your .xls files are valid files?

When I open your VI, you have 3 filenames that are full of garbage characters.  Maybe the filenames are breaking the way the Excel file is being opened.

But if you know what you need to do so that it works okay for you (minimized vs. no change), then just use that.

Message Edited by Ravens Fan on 10-27-2009 11:49 PM

[Yarmouth]

The garbage characters are caused by the fact that I write VIs in LabVIEW of Simplied Chinese version. I just feel curious about the problem while it doesn't affect my present work. Thanks.

[Yarmouth]

Sometimes even in the occasion with the parameter 'minimized' or 'normal' or 'maximized', something wrong will happen unexpectedly because the disability of reading the right data. Can anyone help? It's my first time to meet such volatile problems.