Fully interact with an Excel macro through LabVIEW

[nyc_(is_out_of_here)]

---

@aRCo wrote:

In order to clarify ideas, i uploaded an image showing the code i used to get few information such as "# of sheets", "Book name", "Selected sheet name", "# of objects". This piece of code works fine.

Now i need to access the value of the OLE objects in order to get or set it. Objects are: "WritePath" and "WrittenText" in the WriteToFile sheet and "ReadPath" and ReadText" in the ReadFromFile sheet.

---

As I wrote and linked up, brush up on the Excel Object Model.

You chose this path. You will have to do some work.

[aRCo]

Mmmhhh.. well.. i opened this post searching for practical solutions (if any), not only suggestions. Pieces of sample code, please??

Thanks men!

[nyc_(is_out_of_here)]

You've been given a practical solution. Read up on how to manipulate OLEObjects.

By the way, your subject line is misleading. This has nothing to do with interacting with an Excel macro, because as was written up, the only interaction with a macro is to run it.