I have a checkBox in my excel workbook,and I would like to know in my c# application is tht VBA Excel control(chechkBox) set to true or false. How? Any examples anywhere,or something,so basically how to read data from excel vba in c#

I did what u said,but nutin.Every time I get Sheet1 open.

Yes I do too,using ADO.net and the OleDb connector to read and write,so this is not possible with ado.net

I've moved,thank you,But I cant delete this message here cuz you replied.

Let's say I have five sheets in excel workbook,and each sheet contains one table.Is there any way to Import only active sheet to my C#,What should I do to recognize only active sheet.??any help,ideas?? One more thing,How can I get a data to C# from Excel VBA control(let's say textbox). So I have vba control textbox in sheet and, I want to get textBox.value in my c# project??

Let's say I have five sheets in excel workbook,and each sheet contains one table.Is there any way to Import only active sheet to my C#,What should I do to recognize only active sheet.??any help,ideas?? One more thing,How can I get a dato to C# from Excel VBA control(let's say textbox), So i have vba control textbox in sheet and i want to get that textBox.value in my c# project??