Opening excel sheet inside Active X spreadsheet

[guilio2010]

This should be easy, but I have always had trouble with Active X opening programs.  I created the Excel_Application, called on the workbook to open, the file opens, but from there, I lost.  I would think calling on the Worksheet would be next, then find a Invoke command to extract data and display it on the front panel when I insert a activex Microsoft spreadsheet. but I was wrong.

I did search for examples and researched, but only got to where the file opens.  I need it to display in a spreadsheet on front panel so I can modify number, save the file and close.

Any help is appreciated.

Thanks,

TWK

[Eric_LV]

Hey TWK,

I do not believe it is possible to have an excel spreadsheet actually in your front panel, although Active X is a great way to open an excel file as you have already done.  The only way I know to make an excel sheet appear inside the front panel is using a .NET container.  The .NET container can be altered to include an excel spreadsheet.  

Here is a small tutorial on using .NET

http://zone.ni.com/reference/en-XX/help/371361H-01/lvhowto/create_dotnet_controls/