View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amuel Pouart Amuel Pouart is offline
external usenet poster
 
Posts: 6
Default Unopened workbook values

Is it possible to know the name of a sheet in a workbook without opening the
file?

Or is it possible to get values from a closed workbook - using the
ExecuteExcel4Macro command, for instance - and not knowing the name of the
sheets? - This function requires, as long as I know, that you use the names
of the sheets, and not their numbers.

Thanks

Sam