> Hi,
> In the vb application I am working on, an excel file
> (*.xls) is opened. However, I have to quit the file before
> I close the application, or the excel file stays in
> background.

> How can I quit the excel files while I click on the close
> button, the X on the top-right corner.

> Thanks
> Liu

>-----Original Message-----
>If you need to close file - use Close method of Workbook
object.
>If you need to "close" excel at all - use Quit method of
Application Object

>Mikhail Berlyant
>Data Integrator, Yahoo!Music   www.yahoo.com
>Brainbench MVP for Visual Basic   www.brainbench.com

> I know that, but how to put the quit method in the close
> button, the X button on th top-right cornver? Something
> like:

> Private Sub Command1_Click()
>    excelapp.quit
> end sub

> Thanks

> >-----Original Message-----
> >If you need to close file - use Close method of Workbook
> object.
> >If you need to "close" excel at all - use Quit method of
> Application Object

> >Mikhail Berlyant
> >Data Integrator, Yahoo!Music   www.yahoo.com
> >Brainbench MVP for Visual Basic   www.brainbench.com