Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem using GetObject()
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem using GetObject()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GetObject with Password | Excel Programming | |||
GetObject | Excel Programming | |||
GetObject error 429 | Excel Programming | |||
GetObject function | Excel Programming | |||
GetObject | Excel Programming |