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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007- Saving macros in workbooks 3
Run macro from active workbook whose name keeps changing 20
Saving Workbook 2007 Format in Send Mail Q 11
ADOBE Connection to open Excel workbook 3
How to tell if sheet exists in closed workbook 4
Importing .xlsm, .xlsx with OLEDB 5
file extension shows up twice on attachment 2
forcing specific sheet opening upon launch of .xlsx file 4

Top