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

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.)


"Ron de Bruin" a écrit dans le message de
...
Hi

I think you are right that you can't use the index.

But opening a worknook is in most cases faster.
And you have more control.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Amuel Pouart" wrote in message
...
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

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Amuel Pouart" wrote in message ...
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.)


"Ron de Bruin" a écrit dans le message de
...
Hi

I think you are right that you can't use the index.

But opening a worknook is in most cases faster.
And you have more control.



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Amuel Pouart" wrote in message
...
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

That's what I call info. Thanks a lot.


Samuel Marin


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!