| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named Range: Same Names, Multiple Workbooks with Same Sheet Name | Excel Discussion (Misc queries) | |||
| Reading sheet names in closed workbooks - Is it possible? | Excel Programming | |||
| Return Sheet Names from Closed Workbook | Excel Programming | |||
| Reading Sheet Names/Index from closed file using Biff8. | Excel Programming | |||
| Copying formulas, formats, and sheet names across workbooks | Excel Programming | |||
Linear Mode
