Make visible only some Excel projects

[Ima_P]

Hi,

In an Excel, there is raw information that I use in my Labview application. I don't want to show this Excel to the user, so using ActiveX commands (Excel Application-->Visible-->False) I can do it. However, in this Labview application I want to show some reports in Excel when pushing a button. In this case, I want to show this Excel reports, but not the Excel with raw information. Is it possible to choose the Excel projects you want to make visible?

Thanks

[sendia]

Hi Ima_P,

If you disable de visibility of an Excel Application, you cannot see any document called from or in this application. However, you can open different instances/references of Excel to open different documents. Open one reference to invisible docs and other reference to display the report.

[Ima_P]

Hi Sendia,

I don't know if the solution I have chosen is the best, but it works...

I use different references for each Excel document. Before reading or writing any Excel document I create a new reference and after reading or writing it I close the reference. I hace to do this, because if my Excel document (which I don't want to make it visible) is always opened; and during the execution of my program I generate a new Excel report and I close it before finishing the program, an error appears because it is still opened an Excel document. The problem now, it is that all Excel documents are visible. That is why I use activeX functions to make invisible only the Excel active window, not all the application.

I think that this is not the best solution. Any suggestion?