Reading sheet names in closed workbooks - Is it possible?
Say there are a number of workbooks in a folder. Each sheet's name in
each workbook is an employee's name.
Is it possible to have another workbook in that folder with code that
can compile a list of employee's names (sheet names) and workbook
names.
Or, do the workbooks all have to be opened before code can compile such
a list.
Any ideas?
Ken Johnson
|