What is the code to open worksheet with acces ?

[breukelen]

Good morning,

I used

oleapp=createobject("Excel.Application&quot
oleapp.visible=.T.
oleapp.workbooks.open("c:\my.xls&quot
oleapp.visible=.T.

This works o.k. , it opens the workbook with sheet1.
What is the code,so that it opens for instance with sheet2
Thank in advance for your help.

Gunter

 

[Lightning]

Have a look at the Working Across Applications topic in the Access Help file. This may help you.


HTH

Lightning