ActiveXObject

[PaddyR]

Does anyone know if you can pass an ActiveXObject to a popup child window.
I'm building a script to read an Excel file and it seems the best way is
to have the processing done in a popup (I found I need to destroy the
window to free up the Excel instance).
The problem is it keeps asking if i want to allow ActiveX, of course I do,
so is it possible for the popup to reference the Already created ActiveX
object from its parent.

[VK]

Re: ActiveXObject

> I found I need to destroy the window to free up the Excel instance.

It is not correct. You are closing the Excel instance by using the standard
Quit() method, and (if you want to be hypercorrect with the memory use) you
are dismissing the object container after that by doing objMyExcelInsta nce =
null .

[VK]

Re: ActiveXObject

> by using the standard Quit() method

I meant to say (full syntacs):

objMyExcelInsta nce.Application .Quit()

[PaddyR]

Re: ActiveXObject

My code finishes with this.

oExcel.Applicat ion.Quit()
oExcel = null

But unless I destroy the window it holds the process open causing problems
accessing other spreadsheets.