Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code cleaner
The workbook I am working on has expanded to 7.5M after removing all
unused ranges using the last used cell approach as discussed on several posts here, so I am now trying to reduce the file size using Rob Bovey's code cleaner. I have installed it and read through the help but I seem to be missing something. I have added the com addins button but when I hit ok with Code cleaner ticked nothing happens. I also have tried running the Public Sub CleanAllProjects() macro from the example file whilst having the files open I am attempting to clean but I get an error message "Method 'VBE' of object'_Application' failed." I realise I am doing something wrong bit cant figure out what. Could someone provide an idiots guide to running the code cleaner. Many thanks for any advice. Regards JAmie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
code cleaner
I find mine by Tools|Clean Project
" wrote: The workbook I am working on has expanded to 7.5M after removing all unused ranges using the last used cell approach as discussed on several posts here, so I am now trying to reduce the file size using Rob Bovey's code cleaner. I have installed it and read through the help but I seem to be missing something. I have added the com addins button but when I hit ok with Code cleaner ticked nothing happens. I also have tried running the Public Sub CleanAllProjects() macro from the example file whilst having the files open I am attempting to clean but I get an error message "Method 'VBE' of object'_Application' failed." I realise I am doing something wrong bit cant figure out what. Could someone provide an idiots guide to running the code cleaner. Many thanks for any advice. Regards JAmie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code cleaner | Excel Discussion (Misc queries) | |||
HTML Code cleaner | Excel Programming | |||
Code Cleaner in 2003 | Excel Programming | |||
Code Cleaner | Excel Programming | |||
VB Code Cleaner | Excel Programming |