[Access VBA Central] Opening and Closing Excel from Access

 

I'm using Access to update Excel Workbooks. The code below works to get me through the procedure and closes the application, but an Excel process is left running after the procedure finishes. That is, if you open Task manager, there's no "Excel" in the Applications tab but there's an "Excel" in the Processes tab. Is there something else I have to do to close the remaining process or is there another explanation as to why it remains?

Thanks for your help,

Jnana

Set objXL = CreateObject("Excel.Application")

With objXL.Application
.Workbooks.Open WorkbookName
.
. (Changes to workbook)
.
.ActiveWorkbook.Close SaveChanges:=True
.Quit
End With

Set objXL = Nothing

__._,_.___

Reply to sender | Reply to group

Messages in this topic (1)

Recent Activity:

• New Members 4

Visit Your Group Start a New Topic

MARKETPLACE

Going Green: Your Yahoo! Groups resource for green living

---

Mom Power: Discover the community of moms doing more for their families, for the world and for each other

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___