10-13-2011 11:05 AM
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
10-14-2011 05:53 PM
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/