write data to a non active excel spreadsheet

[jmw50290]

I'm using Excel for the HMI of a data logging application.  I would like to  have several different worksheets depending on the test being performed.  I can write the data to any sheet by making it the active sheet but I need to be able to allow the operator to chose which sheet they want active while data continues to update in the non-active worksheet.  I am using LV8.5 and have the report generation toolkit but don't see how to accomplish what I need.  Thanks, Mike

[josborne]

Wow ... Excel as an HMI ! 

Do really mean that the user will be interacting with the machine through Excel?  Or do you just intend to output data to Excel?

Anyways, I think you want to use Active-X Automation in order to interface with Excel.  Here is an example.

[jmw50290]

Thanks for the tip on active X, I'll give it a go.  Using Excel only to display data that is generated in a loop using yokogawa dm100's and the excel toolkit. Made sense to me as the data needed to be display in column and rows and updated frequently (100 channels, 1 second interval).  What little control will be needed will be done in LV.  Regards, Mike

[dkfire]

Have you ever seen the Multicolumn Listbox?

It's a frontpanel control/indicator and it can display data in cloumns and rows.

And you can have a Tab Control with multible tabs, each with a Multicolumn Listbox. No Excel needed.

[jmw50290]

Thanks for the suggestion.  Yes, I am familiar with it.  Have also used the table control frequently in the past.  Just wanted to do something different this time.