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