Array index out of bounds error using LabVIEW Microsoft Office Toolkit in TestStand

[Big_Will]

I have a TestStand program that generates an Excel Report using the NI LabVIEW Report Generation Toolkit for Microsoft Office.

The program will encounter a Run-Time Error when it executes a step called Excel - Set Cell Color.

This error usually occurs after the program has been running successfully for some time.

This Excel - Set Cell Color step calls a LabVIEW vi named Excel - Set Cell Color and Border.vi from the LabVIEW Toolkit.

This Run-Time Error generates an Error Code: -17324; Array index out of bounds.

The Location is always Step 'Excel - Set Cell Color' when the Run-Time Error occurs.

If I try to Handle Current Error by Retry or Ignore, every Excel step after the one where the error occurred generates a Run-Time Error with the same Error Code.

If I Run Cleanup, all Excel steps to generate the report summary in my program also generate Run-Time Errors.

Do you have any suggestions on how to fix this problem?

[RayFarmer]

Hi,

Can you post a small example highlighting your problem and/or some screen shots showing your error dialogs.

Regards

Ray Farmer

[Big_Will]

Is there a way I can send you an image of the problem?  I have it in .bmp and a little less clear in .jpg.

[RayFarmer]

Hi,

You can't attach bmp files unless you zip them up. You can attach jpgs or png file via the attachment control below the submit post button

regards

Ray Farmer

[Big_Will]

Here it is.

[Big_Will]

Here is the zip file.  It may be clearer.

[RayFarmer]

Hi,

where did the excel step types come from?

You seem to have some Parameters defined in the MainSequence. Does this mean you have modified the Process Model sequence file to pass parameters to the Client sequence file 'Key Switch Cycle Test FIEXED.seq'.

Regards

Ray

[Big_Will]

Hi Ray,

Excel -Set Cell Color is a sub-sequence of another sequence created by another person in our group.  My program uses this sub-sequence.  Here is what it looks like.

[RayFarmer]

Hi,

So where is the array, is that being used to pass one of the parameters in 'Excel-Set Cell Color - green' of Key Switch Cycle Test FIXED.seq?

Ray

[Big_Will]

Hi Ray,

I cannot find an array.  The only one I see is ResultList.  This one seems to be in all Test Stand sequences.  I am not sure exactly how it's used.

I have pulled the sub-sequence out of the main sequence and made a new main sequence with all of the same variables.

Look at it and let me know what you think.

Thanks