safeeullah wrote: when i built it in release mode, my spreadsheet stopped taking in data entries to cells.. 1) Check out you don't have significant code in a #ifdef _DEBUG ... #endif section. Because in release mode, no code would be generated. 2) If the debug mode works fine, and the release mode doesn't, it's usually because the code is weak. There is a probably a bad use of pointers somewhere. - check out the console window for all "exception errors" that might be produced by Excel (or any other ActiveX host). - build the release mode with "Debug Info". And check the ".pdb" box. Doing so, you can put a breakpoint even in release mode. - Add a DebugBreak() statement in your code. This allows to halt the code, start a session, and watch variables, etc. To have this to work properly, it's best to generate a release version with all the debug info (see above). - add a few message boxes in your code, and watch them. That's the most primitive way of solving issues, but sometimes it's enough! Good luck! And if you are to go on with debugging, crash handlers, etc. don't hesitate to buy this book[^].
RSS feed