Cyberdude
07-30-2006, 02:46 PM
Every once in awhile I have an Excel crash, and lately the recovery process gives me a compilation error on a macro in Personal.xls that is using the function "Chr". The error message says "Can't find library". Since I've been using this particular function for a long time, I'm puzzled about what library "Chr" is resident in. The recovery is at a standstill until I comment out the macro line that is using Chr, then by doing a little of this and a little of that I'm able to coax the recovery to completion. When I ask what the problem was, the response is "No error was found" or some such thing. Does anyone know what library "Chr" is in?
Another curious thing that's been happening lately in crash recovery is that the system shows as many as four other workbooks that I did not have open when the crash occurred. Now that's weird! Since I'm able to close them without saving, it's not really a problem.
Another curious thing that's been happening lately in crash recovery is that the system shows as many as four other workbooks that I did not have open when the crash occurred. Now that's weird! Since I'm able to close them without saving, it's not really a problem.