Excel to VB .NET

Woot Woot Woot
Total Noob Alert!!!!!

I am trying to retrieve the values in a column from Excel and load the values into a list box in VB .NET. The column may not always be the same next time, so I cannot just get the same column every time. How do I get just one columns values? Can this be done? Where do I go?

BTW - Sweet forum. I've been lurking for a few days and there are some really intelligent peeps here.

TIA,
Hollywood

Hey Hollywood,

Let's just tone it down a notch, k? I'm not sure of your level of knowledge here.

If you are completely new to MS Office Integration using VB.Net then you would probably want to have a read of the VB.Net Office Automation FAQ (http://www.xtremevbtalk.com/showthread.php?t=160459) and/or the tutorial on Automating Office Programs with VB.Net (http://www.xtremevbtalk.com/showthread.php?t=160433).

Once you are comfortable with these, then we can take it to the next level, which is to try to extract the values you need from the Excel Worksheet.

:),
Mike

Thanks for the info. I ran through it today. I didn't realize it was gonna be this involved. I think I'm ready to proceed and see what becomes of this. Please send more info...

Thanks,
Hollywood

Send you more info??

Why don't you show us what you have so far?

-- Mike

Sorry for not replying earlier. I have pretty much scrapped the project. Thanks for the info you shared. If I pick the project back up and solve it, I'll share my findings.

Hollywood

Ok. But to be honest, I don't use VB.Net to control Excel either. .Net's COM Interop does not quite seem ready for the challenge... maybe in a year or so they'll have some of the kinks ironed out.

Until then I would suggest developing in VB 6.0 or in VBA.

-- Mike

Until then I would suggest developing in VB 6.0 or in VBA.


..and I agree :(

(until VB.NET 2005 and Excel 12.0 is available)