hello !

with Access VBA how to select a sheet other than the first one within an
Excel 5.0 file ???

Thanks

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