creating a table in Excel using ActiveX functions

[colum]

Hi,
I am new to labview and have have a project where i need to create tables in labview using activeX, i cannot seem to get the Invoke node Table (under range) to work, any help would be much appreciated.

[Norbert_B]

This question is not related to LV at all. So in general, this question is more for MSDN (Microsoft Developer Network).

That being said, here the steps you have to implement in LV:

1. Open Automation Server Excel._Application
2. Set property Visible to true (otherwise, you won't see the result unless you save the workbook)
3. Create a Workbool
4. In the Workbook, create a Worksheet (that's what you call a "table")

That's it.

Norbert

PS: Due to "reference lifetime", you want to keep the VI running (e.g. event based waiting for a button press) otherwise Excel will shutdown as soon as you release the reference to Excel._Application.