Excel Automation VS.NET2003

[Gillian G.]

I am having the same issue but while running from a code
module in Access2000. It wont close down the original
excel instance i create in code.

xlWorkSheet.Close
Set xlWorkSheet = Nothing
Set xlWorkBook = Nothing

xlApp.Quit
Set xlApp = Nothing

after this the instance is still visible in the process
list but no longer available (hidden). all my references
to the application have gone out of scope.


curious note* i create a workbook from a template with
this line...
Set xlWorkBook = Excel.Workbooks.Add(sDataDir + "\Site
Summary.xlt")
and save it with this line...
Call xlWorkBook.SaveAs(sExportFile)

if i dont create a workbook from a template it exits fine
but i dont get to use my template or save it.

any ideas?