changing active excel sheet

[Yves]

Hi
how can I change the active sheet in excel with activeX-commands? I haven't found any example yet? I also tried to change the index in "open specific worksheet.vi".

[RayFarmer]

Hi,

Find attached an example to select an active sheet.
The VI is in LabVIEW 6.1 and uses some of the VI from LabVIEW's excel example vi's.

Regards
Ray Farmer

[Yves]

Thanks alot. it works wonderfully.
is it also possible to choose the active sheet by its name?

[RayFarmer]

Hi,

Yes, instead of wiring an integer to the Sheets.Item method, wire a string.

Attached is modified example

Regards
Ray Farmer

[Yves]

Hi

Thanks alot Ray.
it's quite easy this way. do your know a good page where I can downlaod and choose vi's for activeX and excel. por did you made them all by yourself?
regards
Yves Dieplinger

[RayFarmer]

Hi Yves,

No I started from the example VIs found in the LabVIEW\examples\comm\ExcelExamples.llb. Then viewing the available methods and properties and using the help come up with a solution to your question.

There is a Toolset you can purchase from NI, ( http://sine.ni.com/apps/we/nioc.vp?lang=US&pc=mn&cid=5769 ).

Regards
Ray Farmer

[John wong]

hi
do we need to purchase the toolkit in order to transfer the data from labview to excel files?

[KileenC]

To have LabVIEW communicate to Excel, you do not need to purchase the Report Generation Toolkit. The above examples you should be able to open in LabVIEW even if the Report Generation Toolkit is not installed. To communicate, you will need to use ActiveX and understand Microsoft's object model. There is a good tutorial discussing how to integrate Excel into NI software:

NIDZ Tutorial: Integrating Microsoft Excel with National Instruments Software 

And just in case you're interested in the Report Generation Toolkit:
NIDZ Tutorial: Creating a Report in Microsoft Excel Using the LabVIEW Report Generation Toolkit: Int...

Hope this helps. 🙂

Kileen

[Joe_H]

Yves


Here is some VI's that will help you out a lot.