Sheet names from closed workbooks

C

Cresta

Hello
Is it posible to get a list of sheet names from a closed workbook.
(xlsm,xlsx,xlsb)
I have looked at the ADO methods for previous version of excel but cannot
get them to work with 2007!!
Help
Thanks
 
G

Gary''s Student

If the workbook is closed, first open it.
Then copy the tab names.
Then close it.
 
Top