>Hi: I am doing excel automation but am finding some discrepancies, I think, so wanted to check out some things.
>
>1. I usually begin by making the variable that I will be using for excel, by making it public:
>

>PUBLIC oExcel
>oExcel = CreateObject("Excel.Application") 	
>

>

If, by chance, you're doing that because Della and I did it in the Automation book, note that we say clearly that we using a public only for demo purposes. The truth is that a private variable declared and populated in your main program is sufficient, but I prefer to use a property, either of a dedicated automation object, or of the application object.

Tamar