Thierry
I'm *very* new to Access, but fairly proficient with XL. Providing you
have set up your link to the XL app, then
obXlApp.worksheets(2).select or obXlApp.worksheets("Sheet3").select
should work. First example uses the sheet index, whereas the second uses
the worksheet name. (obXlapp should be replaced with your object variable)
FWIW It's seldom necessary to 'select' anything in XL to use it and it
stops any jumping, etc.
HTH and works!!
--
Nick Hodge
Oxford, England
Quote:
> hello !
> with Access VBA how to select a sheet other than the first one within an
> Excel 5.0 file ???
> Thanks