HI , I faced an error while I try to open the excel program in labview, when I tried to run the program, I get the problem but when I delete the stack sequence then it become Ok , and I don't know why, cansomebody please help me.
You don't have any of the error clusters wired, so if there's an error along the way you'll never know. A couple of glaring issues:
You are unnecessarily creating references which you already have. Specifically: you are using the Worksbooks.Application property to get the reference for the Excel application, which you already have. It's an input to the VI!
You must close references in the opposite order in which you created them. Therefore you must use the error cluster to force a sequencing of closures. Your Close Reference functions have no such dependency, thus you cannot know ahead of time which one will execute first.
I would suggest perusing the Excel thread for some examples on how to manipulate Excel via ActiveX.
That question doesn't really make any sense. Automation Open simply opens a reference to an object. It has nothing to do with saving of anything. If you want to save something at whatever period you want then you need to have a loop that runs at that rate and calls the Save method (or whatever it's called) for the class that you're accessing.
