View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cresta Cresta is offline
external usenet poster
 
Posts: 76
Default 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