Hello,
I'm trying to use the "Report Generation Toolkit for Office" but receive Error1.
First I use a subVI to open a new Excel-file, save it an give the Referenz of the Excel Report to another subVI that writes some text to Excel (without open Excel again only by using the referenz)and save it again.
So far everything is working fine.
But now I want to use only the subVI that wrote some text inside the Excel file. Because I have never closed Excel or disposed the Referenz to Excel it should be possible to write some more text to Excel without open the Excel report again. But I receive "Error 1" and I'm not able to perform operation to the Excel file.
I tried to use a global variable to store the referenz of the Excel file and use it to write some more text to the file but the result is again Error1.
Summarized I can open, write data to and save an Excel report if I do it inside of one VI (with subVI's).
But If I try to run one of the subVI's alone it's not working anymore.
I think it's stupid to re-open the excel-file everytime I want to write data to it. I think it's much faster to use the referenz everytime
I hope somebody can help me.
Regards.
Ronny
