VB6 and Excel 97 automation

[netizen]

Hi! All,
I'm working with VB6 and Excel 97 object Library. I would like to know how do i close the instance which is opened upon the following statement.

I'm opening an excel workbook from App.path using the following statement:

strFileName="C:\Work\abc.xls"
Set oBook = Workbooks.Open(strFileName)
Once the abc.xls is opened, i use:
Application.Visible = True , which will show the Excel sheet.

Now the problem is even after i close this workbook using the 'File-->Close' or 'X' mark the excel instance is still open, which I can see using the Task Manager.

I want to know how do i close this instance programatically upon closing the excel workbook or the whole excel environment physically using 'File-->Close' or 'X' mark?

thanks in advance,

Regards,
netizen

 

[GJParker]

try setting your objects to nothing

i.e.

obook.Close 'close workbook
Set oBook = Nothing 'Kill Workbook object
Set Application = Nothing 'Kill Excel Application Gary Parker
Systems Support Analyst

 

[Schweiger]

Try to use application.visible = true before opening the workbook. This has helped me when my instance of Excel wasn't unload when the user closes the workbook instead of the Excel.

Andreas