Access & Excel Automation 'Inner Pane' not displaying

[SadOldGoth]

Hi folks,

I'n using Access XP and Excel XP in a citrix environment. I'm using automation to open a template in excel and then outputting the results of a query to that spreadsheet.

The first time I run it, everything is fine. However, the next time, and everytime thereafter, the excel window opens but the inner pain that holds the worksheet does not display - in fact I can see the launching application through the excel app.

If I view->Full Screen the info is there and when I Close Full Screen the information is there.

Also, when I quit Access and start again, everything is fine for the first time again.

Any ideas?

Thanks,

Jes

 

[SadOldGoth]

Hi Folks,

Just as an amendment, if I put in

xcl.application.displayfullscreen = False

then it behaves properly everytime, it's just that seems a bit of a kludge to me.

Later,

Jes