excel program error 97 HELP

[alan4]

is in the reaxclprueba the error i have been trying to resolve but i can't

[Norbert_B]

alan4,

you still have not given any information on WHERE the error occurs.

Attaching password protected sources serves no purpose as well.

Without any further information, we cannot help you. Sorry.

Norbert

[Norbert_B]

Looking into your code (i received the password via private message), i want to give you this feedback:

- You open the same Excel Workbook FIVE times in different subVIs. You should not do this. Open it once and pass on the reference to it.

- When running the code (using your Excel workbook) i get several dialogs asking if i want to save changes done to the workbook. Selecting "no" several times will create an error dialog as seen here:

It seems that this is what you get as well. True?

- You have reference/object leaks caused by left open references and on the other hand you are closing references too early. When working with ActiveX, the rules of thumb are:

1. Close each reference you opened

2. Perform the close in opposite order than you opened them. Open/Close "embrace" each other like this:

I would expect the error to disappear once you corrected the points above (including some improvements to block diagram style please).

Additional Hint: It seems that if everything is done "properly in the execution with the code as is", the error is caused by an empty string being passed from SELECTEDcellsTDMS.vi to OPENWorksheetTDMS.vi ("String 2" control).

Norbert

[alan4]

really thanks, i think i have improve something with this but now apeears this?? i attached an image too see it better

[Norbert_B]

You are casting a variant type to some dedicated datatype. The error indicates that the data type prototype does not match the actual content of the variant.

Example:

You are trying to cast a string contained in the variant into a numeric value like this:

In your case, you probable try to cast a worksheet into range or similar.

Norbert

[alan4]

that's weel norberth but i don't have nothing like the vi you have posted, i have make some changes and the error continues.. in variant to data, i insert a variant, the type i insert is a string so you are saying that is bad??? why?

[Norbert_B]

If your newly inserted VariantToData conversion is throwing this error, there is definetly something wrong. My code is only an example which would create error 91. But so would also a numeric value in the variant casted to a string data type.

So if you try to cast the variant to string and receive error 91 from this type cast, it is obvious that the variant does not contain a string.

I cannot tell what the real data type is. You have to know. One hint i can give you: Using an indicator for the variant can give you some information upon the data type in it.

Norbert

[alan4]

SO WHAT I MUST NOW? SEEMS LIKE IS EASY BUT, SORRY I DON'T KNOW HOW TO DO IT, I AM ANGRY WITH THIS ERROR,

THANKS!!

OCH!!SORRY ALL MAYUS!! 😞

---

[Norbert_B]

It seems that you missed closing the reference to "Workbooks" and the first instance of "Range". It is possible that those leaks are the source of the error.

[alan4]

after doing it, continues the error... in the last close reference...   ERROR:

Error -2146827284 occurred at Unknown System Error in OPENWorksheetTDMS.vi

This error code is undefined. Undefined errors might occur for a number of reasons. For example, no one has provided a description for the code, or you might have wired a number that is not an error code to the error code input.

Additionally, undefined error codes might occur because the error relates to a third-party object, such as the operating system or ActiveX. For these third-party errors, you might be able to obtain a description of the error by searching the Web for the error code (-2146827284) or for its hexadecimal representation (0x800A03EC).