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

Article View: alt.lang.basic

Article #711

#711

From: 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

Technical Details

Message-ID: <6i9cvu$t1h$1@otis.netspace.net.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fa2c1,37a88d8623775a62,start
X-Google-Attributes: gidfa2c1,public
X-Google-Thread: 10c949,37a88d8623775a62,start
X-Google-Attributes: gid10c949,public
X-Google-Thread: f7646,37a88d8623775a62,start
X-Google-Attributes: gidf7646,public
X-Google-Thread: f75a7,37a88d8623775a62,start
X-Google-Attributes: gidf75a7,public
X-Google-Thread: 1143a7,37a88d8623775a62,start
X-Google-Attributes: gid1143a7,public
X-Google-Thread: f645d,37a88d8623775a62,start
X-Google-Attributes: gidf645d,public
X-Google-Thread: 10ab99,37a88d8623775a62,start
X-Google-Attributes: gid10ab99,public
X-Google-Thread: 110e3b,37a88d8623775a62,start
X-Google-Attributes: gid110e3b,public
From: "Mick" <mick@comtech-solutions.com.au>
Subject: Problem with redisplaying Excel for a 2nd time using VB 5.0
Date: 1998/04/30
Message-ID: <6i9cvu$t1h$1@otis.netspace.net.au>
X-Deja-AN: 349004261
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Comtech Computer Solutions
Newsgroups: alt.lang.basic,comp.apps.spreadsheets,comp.lang.basic.misc,comp.lang.basic.visual,comp.lang.basic.visual.database,comp.lang.basic.visual.misc,comp.os.ms-windows.nt.admin.networking,fr.comp.lang.basic,it.comp.lang.visual-basic,microsoft.public.vb.