Resolving a System Error

[gonger]

I am in the process of implementing a new Excel tool at work but 1 employee had problems with it. Upon executing my macro, a pop-up message said

"System Error &H8000FFFF (-2147418113). Catastrophic Failure"

After he hit ok, a second message said "Out of Memory".

After clearing that message, the file closed.

So, what is this error and is there anything I can do in my macro to avoid this?

Thanks

[shg]

You might give him a fresh copy of the file.

If that doesn't work, have him do detect & repair on Excel.

[djgallegos3]

I found the solution to this error - for at least my situation.
My workbook contains 2 user forms - one is the actual form, the other one is used for designing the actual form. While designing, i ran into this "catastrophic" error.

WHAT I DID TO FIX:
Since I had one extra form at the time (which was NOT my actual form), i tried to R-click > Delete this extra form... didn't delete. Actually, it made Excel bomb and restart itself.

!!! WHEN EXCEL RESTARTED ITSELF, IT FIXED THIS ISSUE !!!

When i looked at my form after the restart of excel, everything was the way i last designed it to. All good!

try to delete an existing form you have one to do it with (this restarted my excel and it worked great). Before, not only could i NOT save (as xlsm) as ANY name, but i also could NOT export the file either (or anything for that matter).

[FDibbins]

djgallegos3 Thanks for the update and suggestion on this fix

(Did you notice that this thread is over 2 years old though?)

[abousetta]

I personally don't mind people providing solutions for problems even if the thread is old as Google and other search providers don't rank according to date. On the contrary, if it's an older thread, it probably will have more hits .

Personally, I like to decompile/ compress/ recompile vba code using MVP Orlando's free application. It's cleared up a lot of problems I have seen with vba. Also of course, there is CodeCleaner which reproduces the modules and forms from scratch. Another big helper.

[FDibbins]

Thats exactly why I thanked them, its always good to get resolution on older threads

[abousetta]

I hate when I google a query and in the end it links me to an old thread with the same problem and no solution. It make me wonder if the problem is that difficult or the OP just wasn't lucky enough to find someone to give them the right answer when they originally posted.

Cheers to all, and to all a good night

abousetta