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

I find mine by Tools|Clean Project

"(E-Mail Removed)" 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
>
>