Excel sheet name in Combo Box

[Guest]

Hi,

I've got an application that imports data from an Excel file. I'd like a
way to fill a combo box with the sheet names in the selected Excel file so
the user can select the sheet they want. Can anyone suggest anything?

Art

 

[Mike McIntyre]

Hi Art,

Here is a link to Ken Getz's really good artile on manipulating Exel with
VB.NET. It includes the logic you need to extract things such as worksheets
which would allow you to create your ComboBox:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp


--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com

 

[Guest]

Mike,

Thanks for the help.

Art

Hi Art,

Here is a link to Ken Getz's really good artile on manipulating Exel with
VB.NET. It includes the logic you need to extract things such as worksheets
which would allow you to create your ComboBox:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_vsto2003_ta/html/ExcelObj.asp


--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com