Do you really open the .xlt file or do you create new workbook based on that
..xlt template?

dim newwkbk as workbook
set newwkbk = workbooks.add(template:="c:\somefolder\Postingsum. xlt")
'do the work
'and close the .iif file
newwkbk.close savechanges:=false
set newwkbk=nothing
'set allyourotherobjects = nothing
application.quit

======
If you're opening excel, then ok. But if you're using an already running
instance of excel, I'd be very hesitant to close the application.



annep wrote:

Dave,
I have your macro saving the iif.file. I then had to add Close the xlt
file.
I just can't get it to close excel.
I added the following lines
ActiveWorkbook.Close
Application.Quit

the close works, but the quit does not.
Anne

--
annep
------------------------------------------------------------------------
annep's Profile: http://www.excelforum.com/member.php...o&userid=18851
View this thread: http://www.excelforum.com/showthread...hreadid=503559

--

Dave Peterson