Program or object defined error?

[notuserfriendly]

Get this from message from Excel. Has no error code. And only happens sometimes. I suspect it has to do with running other applications while Excel is busy working with a high percentage of CPU. In my case it searches in other excel sheets for information and closes every file it searches in. By opening and closing many files sometimes up to 500-600 times it might become too heavy.

Google won't give me much
only this

http://www.dbforums.com/t318856.html

http://www.macropool.com/en/support/faq/error32797.html

but it doesn't say what it really is.

Using Office 2002 SP3 on XP

 

[SkipVought]

Hi,

What is the statement that it errors on?

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[xlbo]

probably a memory leak to be honest - if you are setting variables to reference the files with, you should set them to nothing before re-using - this only really becomes important when you are doing a lot of processing (as it sounds like you are)

Rgds, Geoff

"Having been erased. the document thjat you are seeking. Must now be retyped"

Please read FAQ222-2244 before you ask a question

 

[notuserfriendly]

The thing is I don't know where the statement is, it depends from time to time, normally it's when I'm inside a file reading. Been testing without IE and Messenger open, then it works fine(Skip). And yes I believe it's a memory error but the error message is not a good indicator.
I'm working against clipboard data. I might have forgotten setting it to nothing in some functions will check now (Geoff).

 

[SkipVought]

Can't you hit the Debug Button when the error occurs?

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[notuserfriendly]

No, it kills the function. So that's why I don't know. Anyway did what Geoff told me to, but it didn't work.
I had missed setting some files to nothing even though I closed them.

 

[SkipVought]

Its not setting FILES to Nothing.

Set Objects to Nothing.

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[notuserfriendly]

Meant Objects, sorry

 

[notuserfriendly]

however it doesn't seem to help, seems like it works fine if one just doesn't touch the keyboard during processing time. Maybe a modal should do it.

 

[notuserfriendly]

I've noticed that the error I get is the same one gets if one interrupts the execution of a macro. Seems like it happens when using other applications, like if one of them sends an ESC to Excel.