Sheet names from closed workbooks

  • Thread starter Thread starter Cresta
  • Start date Start date
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
 
If the workbook is closed, first open it.
Then copy the tab names.
Then close it.
 
Back
Top