Import lots of spreadsheets with lots of tabs

Topic

New Reply

I have a directory full of spreadsheets that have 1 to many tabs in each of them.

Each tab is identical in format, just the data is different.

Anyone have any code that can open the spreadsheets and cycle through the tabs? I can easily do the import, but the tab thing has me stumped.

Thanks!

Reply | Quote

Replies

Do all tabs have data in them, or do you need to check to see if a tab has data? I think probably Automation would be the best choice in trying to sort that out. For one thing you need to figure out how many tabs each workbook has. You will have to use the Excel object model to do both tasks, and the sheet property is exposed to automation.

Reply | Quote

Do all tabs have data in them, or do you need to check to see if a tab has data? I think probably Automation would be the best choice in trying to sort that out. For one thing you need to figure out how many tabs each workbook has. You will have to use the Excel object model to do both tasks, and the sheet property is exposed to automation.

I believe all the tabs have data, but I can easily check to see if there is data in the cells.

Reply | Quote

Do all tabs have data in them, or do you need to check to see if a tab has data? I think probably Automation would be the best choice in trying to sort that out. For one thing you need to figure out how many tabs each workbook has. You will have to use the Excel object model to do both tasks, and the sheet property is exposed to automation.

Thanks for the pointer….it helped me figure it all out!

Reply | Quote