Excel gets invisible after closing workbook?

D

Dirk

Hello together,

i have a strange problem:

I wrote a VB6 application that works like this:
- create an Excel.Application object
- open a workbook from an template
- fill data in the first sheet on the workbook
- let worksheet.visible = xlSheetVisible
- let ExcelApp.Visible = True

-> everything looks fine!

At this point it does not matter wether my application runs or is
terminated by the user.
The user can work with the sheet, but if he closes only the sheet (not
the application), the sheet closes and excel becomes _invisible_ !!!
The taskmanager still shows the running excel process!

Has anyone an idea why excel works like that and what to do to keep
excel visible?

The environment:
- Windows NT4 SP6 (i did not checked it on any other system)
- Excel 97 SR2

Thanks in advance
Dirk
 
Top