Determine .sheets.count on a Closed Excel Workbook
Posted on 2003-10-31
I have a quick question that I've been wrecking my brain on...
I'm using VBA inside of Excel, and I'm trying to determine .sheets.count on a closed Excel Workbook.
In a nutshell, here's the functionality that I need...
I have about 1000 folders that I need to loop through, then identify the .xls file inside of the folder and compare the number of sheets to the number of files in the folder. Each folder will have 5-100 different files inside of it... With all of this in mind, I don't want to open each .xls file that I come across just to find .sheets.count and then close the .xls file. Looping through each folder, then looping through each file, then opening the xls... In the end this takes about 7 hours to run this report. I can have my team manually do this task faster.
I've already tried everything that I can think of to try and determine .sheets.count on a closed workbook, but nothing has worked just yet.
Please let me know if anyone has any suggestions. At this point in time, I'm not even sure if it's possible to determine .sheets.count on a closed workbook.
Thanks in advanced!