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.

--
Regards,
Tom Ogilvy


"Jean-Pierre Bidon" wrote:

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