By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,116 Members | 1,319 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,116 IT Pros & Developers. It's quick & easy.

Excel sheet name in Combo Box

P: n/a
Art
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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/de...l/ExcelObj.asp
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com
"Art" <Ar*@discussions.microsoft.com> wrote in message
news:B2**********************************@microsof t.com...
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

Nov 21 '05 #2

P: n/a
Art
Mike,

Thanks for the help.

Art

"Mike McIntyre" wrote:
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/de...l/ExcelObj.asp
--
Mike

Mike McIntyre
Visual Basic MVP
www.getdotnetcode.com
"Art" <Ar*@discussions.microsoft.com> wrote in message
news:B2**********************************@microsof t.com...
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


Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.