Unopened workbook values

  • Thread starter Thread starter Amuel Pouart
  • Start date Start date
A

Amuel Pouart

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
(e-mail address removed)
 
That's true.

However there are serious resons why I don't want the workbooks to be
opened. (My macro is analysing the workbook to check if it can import data
and I don't want any other macro to start on open.)
 
If you open a workbook you can use this to stop code to run.

Dim wb As Workbook
Application.EnableEvents = False
Set wb = Workbooks.Open("C:\Data\book1.xls")
' do your things
wb.Close
Application.EnableEvents = True
 
Back
Top