topic Re: excel program error 97 HELP in LabVIEW

excel program error 97 HELP

alan4 — Wed, 11 Apr 2012 07:55:05 GMT

HI!

i am creating a program to search a word in excel and change it for another word i want...

but when i start the programm, error 97 appears, and i don't know how to solutionate it, i have been reading more posts, but i don't get the best solution can you HELP ME?

take my vi to open it!!!

THANKS!!

Re: excel program error 97 HELP

Gak — Wed, 11 Apr 2012 08:19:34 GMT

The error description is "A null or previously deleted refnum was passed in as an input."

Now, if you see " Open Workbook.vi" , Workbook reference is closed. And you are using workbook Invoke node later in your code. That is why you are getting this error. Remove "Close reference" from that vi and run again.

P.S.. I guess you don't use "Explain Error" feature of LabVIEW to understand why error occurred. You should use that, it is very informative.

Re: excel program error 97 HELP

alan4 — Wed, 11 Apr 2012 08:26:37 GMT

thanks Gak!!

but if i delete this, appears a new error...

error -2146827284

so what can i do?

thanks for your atention!

Re: excel program error 97 HELP

Gak — Wed, 11 Apr 2012 08:31:04 GMT

Run your code in highlight mode. See where exactly you are getting error. What are inputs to that particular node.

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 07:42:21 GMT

goodmorning gak, i continue with the same problem, i expect you will be able to resolve it....

thanks...please help me!!

THANKS

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 07:51:00 GMT

Maybe gak is going to debug the VIs for you, maybe not.

The forums are not meant for people to debug other developers code. It is a forum where you get information on how to improve your knowledge in NI tools (maybe even 3rd party stuff) in order to be more successfull. So all participants expect you to be willing to improve yourself by putting some effort in the learning on your own.

That being said, i want to point out again (as gak already did): Use highlight mode and probes to identify WHERE the error occurs. The error number you stated above indicates an ActiveX error, so it is something happening in Excel. The property nodes simply pass this Excel error to your code for further handling.

The error can occur for instance when trying to access invalid objects like "not present sheets" or similar.

Norbert

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 08:01:53 GMT

SORRY, i have been working with this until yesterday and works fine, but yesterday start giving errors and now give this error every moment...i don't know what to do...i have spend all day with this and i don't find a solution...thats the reason i have attached the vis...

can you help me please
???

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 08:19:58 GMT

This still says nothing WHERE that error comes from. You seem to think that everyone is able to reproduce the issue on his local machine.

But the error could have many sources, many of them possibly linked to YOUR specific machine:

- Coding error (reproducable anywhere)

- Depending on Excel/LabVIEW version (reproducable on machines only having the same Excel/LabVIEW version)

- Certain settings (reproducable only on machines using the same settings, so you got to provide those)

- Regional settings (excluding many PCs around the world not matching your regional settings)

- Certain registry entries (most likely not reproducable anywhere else than your machine)

- Corruption of components (most likely not reproducable anywhere else than your machine)

You gave some kind of hint to yourself on the other hand with your reply:

If the code worked till yesterday without that specific error: What have you changed on the code yesterday? If you revert your code to the version of the day before, does it again work?

Norbert

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 08:24:36 GMT

i haven't change nothing, i use excel work in .xls, and labview 2010 sp1...

i have no change nothing thats because i am angry...i don't know what more to see, i have done lot of things...change directories... but nothing...

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 08:36:55 GMT

Have you tried rebooting the system?

I wonder if the ActiveX interface is stuck in an invalid state. This should create the error in the "Automation Open" function.

There you see, knowing WHICH function throws the error is fundamental for helping you to debug this....

Norbert

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 09:39:04 GMT

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

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 11:00:57 GMT

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

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 11:54:50 GMT

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

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 12:09:30 GMT

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

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 12:55:55 GMT

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

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 13:05:35 GMT

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?

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 13:13:05 GMT

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

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 13:42:38 GMT

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!! 😞

Re: excel program error 97 HELP

Norbert_B — Thu, 12 Apr 2012 13:51:29 GMT

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.

Re: excel program error 97 HELP

alan4 — Thu, 12 Apr 2012 14:13:16 GMT

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).