>Hi Cetin
>
>Yes I am declaring another variable as oSheet=oExcel.ActiveSheet, but I am releasing the oSheet object before issuing the oExcel.quit and releasing the oExcel object. Is this the incorrect way to go about this? Or should I not be using the oSheet at all?
>
>Thanks
>Darren
Darren,
I almost never do that. It might be the point. I generally do like this:
with oExcel.ActiveWorkBook.ActiveSheet
.Something
vs
oSheet = oExcel.ActiveWorkBook.ActiveSheet
oSheet.Something
I can't say it's the incorrect way. Just not using like that and not having problems it comes to mind. Excel leaving open in processes suggests there is a hanging reference somewhere.
Cetin