|
-
Feb 7th, 2008, 02:47 PM
#1
Thread Starter
Junior Member
[RESOLVED] Excel.exe still running after Wb.close and x.quit
Hello there
I am writing an export routine in MS acess 2000
It opens up an excel file and I feed data into the worksheet, however when all is done, and the file is saved, and I send the command to close the excell application it looks liek excel closes fine, but it is still running in the background if I check the taskmanager, and it seems only when I close acess that excel also shuts down.
Here is the start and end to my code
...
Dim x As Excel.Application
Dim ws As Excel.Worksheet
Dim wb As Excel.Workbook
Set x = New Excel.Application
Set wb = x.Workbooks.Open("C:\templatefile.xls")
x.Visible = True
Set ws = wb.Worksheets("Sheet1")
there is then some code which feeds information to specific cells in the worksheet, and that works fine...
and at the end
ws.SaveAs Wrk_File_Name
wb.close
x.Quit
...
I set excel to be visible and it runs great, and the code to paste my information to cells and formating works great. at the end the applicaiton saves and the excel appears to close and I am returned to my access application. However, if I check excel.exe is still running in the background on my pc.
any suggestions??
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|