How to generate the handle(Refnum) of excel

[Brzhou]

Hi Sir, 

I am reviewing the labview code, not sure how to generate or say where to get this excel handle.

As well as other kind of handles for third-part tools.

Thanks.

[MaSta · Accepted solution]

There are several alternatives. Maybe they're better.

One alternative is ActiveX. Another is to use built in VIs for access to Excel, as far as I know part of the Report Generation Toolkit.

The best way is to use royalty free or paid third party tools like CLAUDIE or what else there is. More convenient. 

[Brzhou · Accepted solution]

Hi Sir,

This way, right ?

By the way, how to add more in that list ?

Thanks.

[rolfk]

---

@Brzhou wrote:

Hi Sir,

This way, right ?

By the way, how to add more in that list ?

---

Do you see the Browse.... line at the end? Have you tried that?

The menu only shows the ActiveX classes that have already been loaded. (And once an ActiveX Automation Server has been loaded it stays loaded until you quit LabVIEW).

[Brzhou]

Yes, i saw that:

Also from the tool function, i can import Active X:

But what is the relationship ? need to import first ?

Thanks.

[rolfk]

The first is simply to associate a specific refnum to an ActiveX class.

The second simply creates such a refnum on the fly and adds it to the menu palette. It's just a convenience function.