ExcelBanter - Sheet names from closed workbooks

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sheet names from closed workbooks (https://www.excelbanter.com/excel-programming/420830-sheet-names-closed-workbooks.html)

Cresta

Sheet names from closed workbooks

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

Gary''s Student

Sheet names from closed workbooks

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

All times are GMT +1. The time now is 01:25 PM.