Hi All,

I have a problem with an MS Access app i have. It opens an excel workbook and populates it with Information. This works great but when I choose the button to run the process again it crashes with "run-time error 462:" I think this is related to not closing the object correctly:

Dim CHApp as Object
Set CHApp = CreateObject("Excel.Application")

What I need to do is check to see if the object already exists before I re-run the process so that it does not try to re-create the object.

Any Ideas on how best to achieve this.

Cheers