exiting excell won't work!!!!

[parkfairfax]

I am trying to exit excell from a Access application.

Using "Application.close " closes everything, I just want to close Excell.

Any ideas?

Thanks,

garry

 

[bondm007]

How did you connect to Excel?

Through:

Dim xlApp as Excel.Application
Dim xlWBook as Excel.Workbook

Set xlWBook = GetObject("C:\File.xls&quot
Set xlApp = xlWBook.Parent

xlWBook.Save
xlWBook.Close
If xlApp.Workbooks.Count = 0 Then
xlApp.Quit
End If

Set xlWBook = Nothing
Set xlApp = Nothing


Let me know if this help...