Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Out of Control File Size
Good day. I have a series of worksheets that I have created an application
with and control the logic and functionality through Excel. Why? Cause I have the software and it does the job - for now. Well, after designing and developing the application, I noticed that it continues to slow down in speed with every run I do. To the point now where clearing out 15-20 cell values takes 1-2 minutes. I read on the forums that Excel holds onto old values/references or something, but I don't quite understand it. What I need to ensure is that everytime I close my xls file, I need it to clear/delete/remove any and all unused references. I'll gladly share the file with anyone to see what I've done, simply post something on here and we can discuss - or send me a msg on MSN Msger (dawghouseinc). I'm going crazy with the molasses-like performance. I've cleaned my code, modulized all common routines in public functions, etc. Any suggestions would be great. Components used: Command Buttons, Option Buttons, multi-sheet references, VBA code on worksheets and 1 module (Module1). Thanks, JCH -- Dawg House Inc. "We live in it, therefore, we know it!" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Size With Macros Has Increased From Its Origina Size | Excel Discussion (Misc queries) | |||
Screen Size Control | Excel Discussion (Misc queries) | |||
Graph size control | Excel Discussion (Misc queries) | |||
BUG: Font Size / Control Size Changes | Excel Programming | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming |