dear All,

Exporting data from acceess Excel-template and printout a selection
Close NoSave
First run is Ok
Second run triggers error 1004 'Application-defined or object-defined error'

What's wrong in this closing-code ????

'Print and close excel (no save)
Range("A1:K" & Trim(CStr(iRow))).Select
Selection.PrintOut Copies:=1, Collate:=True
xlApp.ActiveWorkbook.Close SaveChanges:=False
xlApp.Quit
Set xlApp = Nothing

Thanks,

Filip