If the workbook is closed, first open it.
Then copy the tab names.
Then close it.
--
Gary''s Student - gsnu200817


"Cresta" wrote:

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