Problem with redisplaying Excel for a 2nd time using VB 5.0

Thread View: alt.lang.basic

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Mick Thu, 30 Apr 1998 00:00

#711

Author: Mick
Date: Thu, 30 Apr 1998 00:00

25 lines
2092 bytes

What I am trying to do,

I am opening an instance of excel from within VB using the following code.

application = getobject(, "Excel.application.8")

If the user closes the Excel application using the top right hand close X
symbol on the window before VB can close the application, then next time the
VB application reopens Excel using the Getobject method, the Excel
spreadsheet becomes transparent (ie. the contents of the windows desktop
appears inside it).

Does anyone know of a way around this problem.

If you let VB open and close the Excels preadsheet all is fine, it's only
when
the user intervenes and closes Excel manually and then let the VB
application
reopen Excel that the problem occurs.

With thanks in advance.

Mick Burian
mick@comtech-solutions.com.au

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads