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".
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
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 ).
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: