Excel and Macro with Labview

[za3im_ensa]

Hello every body,

I have to read to excels files int order to treat them and generate graphs ( 3 graphes) in another excel file. to do that, i want to use the Macro for Excel.

How can i do, I want to write my basics codes VBA even in Labview.

Tks for your help

[Norbert_B]

Maybe you find this page interesting.

hope this helps,

Norbert

[za3im_ensa]

thanks for the replay,

I'm using Labview 2010. I can't those files in attachements !

[Norbert_B]

It also requires the Office Report Generation Toolkit.....

So maybe i shorten this and tell you that the toolkit includes a VI called "Excel Run Macro.vi". Within this VI, an ActiveX call is done to the Excel Application class called "Run" taking many optional arguments.

So working with ActiveX to interface with Excel will give you the needed toolsuite.

Please refer to msdn.microsoft.com for specific help on Microsoft products (like Excel). You can use this link for an easier start.

hope this helps,

Norbert

[smercurio_fc]

There is also an example that ships with LabVIEW that shows you how to run a macro in an Excel workbook.

In the future, please perform a search and investigate the examples before posting.