See Re: Manipulating open excel sheet for (a) working code on taking control of an existing instance of Excel and (b) reasons why this is not a good idea. Any of the things I mention could be the cause of the erratic behaviour you report. There may also be other issues I haven't thought of.

Regards,

John Davies