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 |
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 |
All times are GMT +1. The time now is 07:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com