After open Excel workbook from C# by excel.Workbooks.Open(.....
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thanks a lot! Your code is working fine.
OK, CheckBox is a Shape....but
1. How can I know I need .OLEFormat.Object?! From what document, help file or what ever source?
2. I want to confirm that if the check box is not checked, the return value is a negative value, instead of a 0.
3. I want to know more: How about If the check box is an ActiveX Control?
Response to your subsequent questions:
1. Refer MSDN for info on VBA.
http://msdn.microsoft.com/
2. Yes, this is true. Its -4146 to be precise.
3. The shape's Type will tell u whether its a form control or an active x control. For a Form control, the shape's Type property is msoFormControl, whereas for an active control, it is msoOLEControlObject, you are better off using the OLEObjects property. Refer this for more details: http://msdn.microsoft.com/
Thanks for telling me the links.
I have just tested that following code not works:
Microsoft.Office.Interop.E
(Microsoft.Office.Interop.
where "CheckBox1" is an ActiveX Control. The error massage is
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.
If the check box is a Form Control, the code works fine.
Guess u missed my point earlier
>> you are better off using the OLEObjects property
Use it this way:
(Microsoft.Office.Interop.
I have noticed that for C#, you need to identify the types specifically, while VB.Net is more lenient towards it.
This works in VB.Net, but not in C#
sheet.OLEObjects("CheckBox
since the property Object is not defined for class Microsoft.Office.Interop.E
Thank you.
Yes, this will work:
Microsoft.Office.Interop.E
(Microsoft.Office.Interop.
However, what I need is the Value property of CheckBox1, an OLEObject gets no such property:
MessageBox.Show(cb.Value.T
will cause
Error 1 'Microsoft.Office.Interop.
Business Accounts
Answer for Membership
by: sudheeshthegreatPosted on 2009-08-02 at 23:21:52ID: 25002197
Checkboxes are stored in worksheet.Shapes.
Select allOpen in new window