Excel report ActiveX missing methods

[michele.santucci]

I need to password protect Excel reports.

In the recent past I found a way to do it but it requires to handle the Excel files already saved and disposed.. I cannot use such solution (that uses OpenXML) in the currect workflow.

I tried to use an ActiveX oriented approach following some of the info collected on this forum.

Unluckly any attempt has failed either because I cannot undestand wich node was being used or because some references were missing in the example provided... the only example I've been able to replicate is this simple diagram:

But as you can see no methods populate the Invoke node ... I cannot understand how to make it work... and this's pretty strange since by any other means report toolkit or any other Invoke Node instances are working fine.

[ooth]

This will probably help

https://knowledge.ni.com/KnowledgeArticleDetails?id=kA00Z0000019KZNSA2&l=en-US 

[michele.santucci]

😓I cannot change neither Labview bitness neither Office bitness... I'm **bleep**ed... 

[ooth · Accepted solution]

Did you try these steps?

1. Right-click the Excel._Application reference to display its options.
2. Go to the Select ActiveX Class option, then, click the Browse… option.
3. Once the Select Object From Type Library window is displayed, click again on Browse…
4. Follow the path where the Object Library is located, for both Word and Excel the default path is C:\Program Files\Microsoft Office\root\OfficeXX\, where XX is the version number

• For Excel: It will be necessary to change the File Type selector to All Files (*.*) to be able to see the intended executable, its name is EXCEL.EXE.

5. Once you load it, you will be able to select the Application (Excel.Application.XX) option, where XX is the version number.

[michele.santucci]

Excuse me ... I've been foulded/discouraged by the original post that pointed on the bitness.

Anyway I followed your hint and I found to point to the correct object after that I think everything self fixed because now I can see all methods without further need to select the class... weird but it works.

thnx.

[michele.santucci]

I think that this fix triggered some issues... now If I try to use something that uses the Report Toolkit I got this:

How can I fix this?

[ooth]

Maybe click on one of those errors and show a picture of what isn't wired correctly. Then I can compare it to my VIs. For example here is my Find and Replace (str).vi

[michele.santucci]

here it is...

the object with unwired or bad terminals should be the Range Invoke node but it looks correct:

[michele.santucci · Accepted solution]

Wait... I made a Clean Up Diagram and it fixed ... 

[Eric1977]

Look at your registry settings too.

https://forums.ni.com/t5/LabVIEW/Please-suggest-how-to-speed-up-data-write-into-Excel-report-from/m-...