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.
 

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

Run macro from active workbook whose name keeps changing 20
Help with copying a sheet from One workbook to another workbook 1
Excel 2007- Saving macros in workbooks 3
ADOBE Connection to open Excel workbook 3
Saving Workbook 2007 Format in Send Mail Q 11
forcing specific sheet opening upon launch of .xlsx file 4
file extension shows up twice on attachment 2
Save As and new workbook new name used in existing code 8

Back
Top