Hi I am using DSOFramer to embed excel into a winform.
The excel workbook has only one sheet which contains a dropdown.
How can I access that dropdown from my C# code in my winform.
- Thanks.
Thom - 23 Sep 2004 16:15 GMT
How do you embed xl with dsoframer? What is dso framer?
> Hi I am using DSOFramer to embed excel into a winform.
>
[quoted text clipped - 3 lines]
>
> - Thanks.
Paul Clement - 23 Sep 2004 17:46 GMT
¤ Hi I am using DSOFramer to embed excel into a winform.
¤
¤ The excel workbook has only one sheet which contains a dropdown.
¤
¤ How can I access that dropdown from my C# code in my winform.
This is VB code but essentially you work off the ActiveDocument object (which is a Workbook when
using Excel) for all of your automation:
FramerControl1.Open "E:\My Documents\Book10.xls"
MsgBox FramerControl1.ActiveDocument.Sheets("Sheet1").ComboBox1.Text
Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)
Coder - 23 Sep 2004 19:47 GMT
Excel._Worksheet sheet = wb.ActiveSheet as Excel._Worksheet;
sheet.DropDowns("DropDownName");
Excel.DropDown dropdown = sheet.DropDowns(1) as Excel.DropDown;
http://www.xpcoder.NET