Re: Problem w/Killing Excel from Access

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 07/25/04 

Date: Sun, 25 Jul 2004 16:15:02 GMT

For more along the lines of what Stan mentioned see
Program won't quit
http://www.tushar-mehta.com/excel/vba/xl_doesnt_quit/index.htm 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <EC5B3B41-0C25-4DD8-ACB8-79C0B9517D9F@microsoft.com>, 
Kev@discussions.microsoft.com says...
> Can anyone help me out with this one?
> I am trying to populate a spread*** with some data from Access. All code resides in Access. My problem is after I run the code below; Excel continues to run in the background. I have tried to delete the Quit Method and set the Visible Property to True and then manually close the application. But when I check the Task Manager, I still find Excel.exe running in the background.
> 
> Dim xlJEs As Excel.Application
> 
> Set xlJEs = New Excel.Application
> xlJEs.Workbooks.Open strJETemplate
> 
> strSaveAsJeName = "JrnlEntrySalesTax" & Year(Date) & Month(Date) & ".xls" 
> ActiveWorkbook.SaveAs Filename:="C:\PS\84Jrnl_Uploads\" & strSaveAsJeName, FileFormat:=xlNormal
> xlJEs.Application.Quit
> Set xlJEs = Nothing
> 
> Does anyone have any ideas?
> 
> 
> Thanks,
> 
> Kev
> 
>