Opening Excel worksheet from Acess

[jimbojr]

Friends,

I'm using the GetObject method to open an Excel worksheet from Access. The trouble is that Excel launches, but nothing is visible.

I tried using the Activate method and the Visible method to display the workbook and sheet (there's only one). But, no success.

Any help is appreaciated.

Jimbo

 

[Philem]

Hullo. Well, going out on a limb here, but I would think you'd need to set the Visible method of Window 1 to true. So:

With wb
   .Windows(1).Visible=True
End with

HTH

P