Open work book

Hi
 
I just started learning Activex-Excel. So i tried to run few example programs but for all the programs i am getting error message"Error 97" or "error 1"
 
What it means
 
Thanks

Could you at least provide the name of the one of the examples that you are getting the error from?

If you could let us know which examples you've had this trouble with, it could be very helpful. If I recall correctly, I ran into 'Error 97' previously looking over some examples. Recompiling the VI fixed the problem. Perhaps you could give this a try?

Thanks Dennis and corys
Attached the example programs


Open Book.vi:
http://forums.ni.com/attachments/ni/170/345147/1/Open Book.vi


Open Work Sheet.vi:
http://forums.ni.com/attachments/ni/170/345147/2/Open Work Sheet.vi

You don't have to post code that ships with LabVIEW. The names would have been enough.
You cannot run these VIs by themselves. Open the top level example called Write Table to Excel. The function called Open Excel and Make Visible has to be run first to start Excel and get a reference to it.

<img src="http://forums.ni.com/attachments/ni/170/345152/1/Open%20Workbook.PNG"> Specifically, the code will return an error because a reference is passed to the property node which does not actually direct LabView to an open instance of Excel. An 'Automation Open' is needed.Message Edited by corys on 07-30-2008 10:06 AM


Open Workbook.PNG:
http://forums.ni.com/attachments/ni/170/345152/1/Open Workbook.PNG