Combine VBA Modules to Speed Performance???

**Jester0001** · 01-30-2013, 04:53 PM

Can I get away with combining VBA modules into one module to speed performance of Excel?

I have noticed when opening or closing my Excel file that contains 10 modules that each module is separately loaded/unloaded in the VBA editor window. I also assume that Excel does this when the file is opened/closed without the VBA editor window open. This results in it taking ~5 seconds for the file to open or close.

I was wondering if I copy and paste all the modules into one module if that would make Excel open and close faster. Some of the modules will call upon other procedures/functions contained in a different module.

Running WinXP Excel 2003

**Norie** · 01-30-2013, 05:10 PM

Putting all the code in the same modules won't speed things up.

Are you sure it's the code that's the problem?

You mention the workbook takes ~5 secs to open/close, is there code running when you open/close?

**Jester0001** · 01-30-2013, 06:47 PM

Yes, I have code to hide/show buttons based upon the file name when the file opens. Since putting all the modules together won't increase performance then I will just leave them as it is. The performance isn't a big issue, and I believe it is more correlated with my system configuration (slow HDD, slow processor, low RAM).

Thank you!