Re: [Access VBA Central] Opening and Closing Excel from Access

 

You close it explicitly.  I found this:

Public Sub SaveFig()
On Error GoTo Checkerror

objXLApp.Quit
Set newChart = Nothing
Set objResultsSheet =
Nothing
Set objChartSheet = Nothing
Set
objXLBook = Nothing
Set objXLApp = Nothing

Exit Sub

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group

Messages in this topic (5)

Recent Activity:

• New Members 6

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

.

__,_._,___