C# checkedlistbox.items.add problem

I am trying to have a checklistbox populate from certain criteria out of an excel spread sheet. When the code reaches the Microsoft.Office.Interop.Excel.Application xl portion of the code. The Form disappears and then reappears but the code will not run past this point. What am I doing wrong?


********************************************************************************************************************
int cntr = 2;
            Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application();
            Workbook wb = xl.Workbooks.Open(@"C:\Users\rciner\Documents\GROUP MUSTER.xls", 0, false, false, false, false, true, Missing.Value, Missing.Value, true, false, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
           
            xl.Visible = true;
            Worksheet ws = (Worksheet)wb.Worksheets[1];
            Range aRange = ws.get_Range("a" + Convert.ToString(cntr), Missing.Value);
            Range lRange = ws.get_Range("l" + Convert.ToString(cntr), Missing.Value);

            checkedListBox1.Items.Add("ciner");
rciner313Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
SAMIR BHOGAYTAFreelancer and IT ConsultantCommented:
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
Have you put a breakpoint and checked values of xl, wb, ws...
0
 
rciner313Author Commented:
I have put a break point in and i got the error : A first chance exception of type 'System.Runtime.InteropServices.COMException' occurred in MOB_Traning_Data.exe

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
AndyAinscowFreelance programmer / ConsultantCommented:
OK - so that is why it stops.

Do you have Excel installed on this PC ?
0
 
rciner313Author Commented:
when i press F5 to continue the program past the break point it does not respond. I have excel on this PC and I have used this method for comboboxes and it works there, just not with the checklistbox.items.add portion.
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
Exactly which line results in this error you get ?
0
 
rciner313Author Commented:
Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application();
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
>>I have used this method for comboboxes

In this application?
Check if you do something different in code prior to the above line (I assume you do use the same line of code)
0
 
rciner313Author Commented:
I have typed it out and copied and pasted it, nothing seems to work. Here is a samples from a place where it works. I am wondering if there is a glitch with the private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) that causes the freeze with a checked list box:

int cntr=0;
            char col = 'a';
            int colcntr = 0;
            int lccntr = 1;
            cntr = comboBox2.SelectedIndex + 2;
            colcntr = comboBox1.SelectedIndex + 1;
            Microsoft.Office.Interop.Excel.Application xl = new Microsoft.Office.Interop.Excel.Application();
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
I've never tried to automate excel (or other COM based application) from a managed (eg. C#) application.  From unmanaged code (C++) one needed to 'start' support of COM via a fuction call BEFORE any attempt to use it was made.  Typically this would be done at application start (and the shutdown of COM support was performed when the app was stopped).

I'll see if I have time next week to make a small automation of excel attempt from C# code.
0
 
rciner313Author Commented:
The problem seemed to be a conflict with the software. I reloaded windows 7 and c# and now it works. Thanks for your help though.
0

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
rciner313Author Commented:
I reloaded windows 7 and c# and now the problem is solved
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.