Problem using GetObject()

[Jean-Pierre Bidon]

Hi,
In my VB Excel Application, I use "GetObject()" to open a workbook, reading
a range in a worsheet, all that being invisible to the user. And then I
close the workbook.
I have to do this several times (getobject, reading a range, closing) in the
same run; it seems to me that the repetition of this cycle is source of
trouble.
After the second or third sequence, I get an error message "Error 1004 - The
'Range' method of '_Global' object failed.".
Thanks I you could help.
--
Jean-Pierre Bidon
Interstat
5 place de la République
75003 Paris
Tél: 01 45 49 19 17

 

[Guest]

I suspect excel is never being released. with your application still
running, look in the task manager and see if you have residual copies of
excel running. If so, you need to clean up your code to release excel.

 

[Jean-Pierre Bidon]

Thanks Tom,
Excel is still running between each execution of the cycle (getobject,
reading, closing), it is normal as it is a VB Excel application and that
there is a workbook open all the time (this open workbook is not the one I
try to open with GetObject, it is another one).
However, I check with the task manager of windows, and there is one, and
only one, instance of Exel running. However, when I close the "GetObject"
workbook each time, it seems as if it were not "well" closed when I reopen
it later.