excel program error 97 HELP

[alan4]

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

[Gak]

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.

[alan4]

thanks Gak!!

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

error -2146827284

so what can i do?

thanks for your atention!

[Gak]

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

[alan4]

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

thanks...please help me!!

THANKS

[Norbert_B]

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

[alan4]

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
???

[Norbert_B]

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

[alan4]

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

[Norbert_B]

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