2 Visual Basic Questions

[Mom92129]

Any help you guys & gals could give would be a HUGE help. I have two questions regarding a VB program I'm writing.

1) I have a form that the user will click "browse" to locate a certain Excel file. After selecting the file, the file name and path go to a list box. However, many of the Excel files the users will be using will have multiple tabs. How can I get all the available tabs to appear in another listbox for the user to select?

2) The program will interface with the database via a listbox screen on a VB form. While the program is processing the changes in the database, I would like it to keep a lot of the records it's changing in another list box. How can that be done?

Thanks!

 

[dchill]

Once you have opened the spreadsheet of interest, you can then access the worksheets. They are,

For intI = 1 to excel.application.worksheets.count
list.add excel.application.worksheet(intI).name
next intI

This may not be the exact syntax, but it should be close enough to get you going in the right direction