List Excel Tabs

[meyerryang]

I have a tough question. If you are importing an excel spreadsheet is there
anyway to list the tabs in the spreadsheet outside of the wizard?

For example, I create a button that populates the directory name of the
spreadsheet in a textbox. Now that the spreadsheet is seleted how can I get
a listbox to show all the tabs? Any ideas would help. Thanks.

 

[pietlinden]

I have a tough question. If you are importing an excel spreadsheet is there
anyway to list the tabs in the spreadsheet outside of the wizard?

For example, I create a button that populates the directory name of the
spreadsheet in a textbox. Now that the spreadsheet is seleted how can I get
a listbox to show all the tabs? Any ideas would help. Thanks.

if you use Excel automation, you can access the worksheets collection
of the workbook object. Then you'd just iterate through those and
write the individual names to the textbox/listbox...