PDA

View Full Version : XLS size restriction?



Mahahaava
01-14-2009, 01:30 AM
Hi,

Excel 2003 SP3
Windows XP Pro SP3
Multiple HW sites

Question:

Why does Excel intermittantly "close shop"? I have encountered several situations recently where VBA code is not run unless I either add a MsgBox or run the code through the debugger... My XLS is > 3 MB. Is the code too large or what? Would this be corrected by upgrading to 2008 (or whatever)?

By saying "not run" I mean that no errors are shown but the Sub is not run at all..

Example:

Choosing an index from a dropdown ComboBox will result in the previous index being selected -- run Debugger and the correct index is selected?!?!?!?

Anyone know what the "#?#& is going on?

/Petri

PS XLS size now >3 MB

lucas
01-14-2009, 08:09 AM
Petri,
I don't think the size of the excel file is the problem. I have several 15mb files that run fine on 2003.

You mention combobox's, are they activeX comboboxes, data validation drop downs or combo's from the forms toolbar. Also are they on the sheet or a userform?


If they are activeX then maybe you could post the code you are using behind them.....

Paul_Hossler
01-14-2009, 08:19 AM
Try running the free (and very good) Code Cleaner

http://www.appspro.com/Utilities/CodeCleaner.htm

Paul