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

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



Mon, 16 Oct 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

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

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

3. problem with ODBC in Excel 5.0 using VBA and ODBC API

4. Replacing field values using 2nd excel worksheet

5. Using unbound textbox to locate values in a datagrid 2nd time

6. Using unbound textbox to locate values in a datagrid 2nd Time

7. looking for financial and statistical libaries (e.g.time series) - VB 5.0 or VC 5.0

8. ADODB.recordset filter problem - 2nd time!

9. Excel Execution from VB Fails on 2nd Attempt

10. 2nd Time Editable Parent Child form in VB

11. True DB Grid 5.0 and VB 5.0 using RDO

12. True DB Grid 5.0 and VB 5.0 using RDO

 

 
Powered by phpBB® Forum Software