Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XP to 97 VBA error
I have a program that works fine in Excel XP, but when
someone tries to run it in 97 it shutsdown Excel. It uses a user form, but the error doesn't occur until the code reaches a line that inputs text into a cell. This is not the first time in the program that text is entered into a cell. The program continues on and runs the entire program, but then shutsdown Excel. I don't really have a clue why it continues to do this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XP to 97 VBA error
This may not be it, but I think I'd build a new workbook with enough data to
test the macro. If the new workbook causes xl97 to crash, then this wouldn't be the problem. But if the new workbook doesn't cause xl97 to crash, then maybe (just maybe), you've got a corrupted workbook (or worksheet). xl2002 seems to be able to tolerate a little(?) corruption better than earlier versions. If this turns out to be the case, maybe it's time to rebuild that one worksheet to see if that helps. Reed wrote: I have a program that works fine in Excel XP, but when someone tries to run it in 97 it shutsdown Excel. It uses a user form, but the error doesn't occur until the code reaches a line that inputs text into a cell. This is not the first time in the program that text is entered into a cell. The program continues on and runs the entire program, but then shutsdown Excel. I don't really have a clue why it continues to do this. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions |