Originally posted by Blobby
SHouldnt it be

Public xlapp as NEW excel.application

anyway?
No, phinds's code is fine is this regard - the above will give you less control as to when Excel starts as you starting it instantly with the "New".

Anyway, for Excel, you need to call the "close" or "quit" or equivalent function for every object you use, as setting them to Nothing merely detaches the object reference from VB. You need to just look at all the objects you are using and make sure they all get closed.