How to use the VBA Code Cleaner?

[Jeffrey20]

VBA Code Cleaner

Hi! I just can't seem to figure out how to use the Code Cleaner, after installing it I can't find any option to use it :S

I'm using Excel 2013 and W8 (if that's relevant).

Thanks!

------------

Also, if someone knows, why does importing and exporting the code reduces the size? What kind of "junk" is stored and why? and when?

Thanks!

 

[RoryA]

I have it working with Office 2013 so I don't believe that is true. Although I do have multiple versions of Office installed - I will try and test a single installation of 2013 when I have time (the only one I have currently is 64bit so won't work).

 

[Jeffrey20]

I have it working with Office 2013 so I don't believe that is true. Although I do have multiple versions of Office installed - I will try and test a single installation of 2013 when I have time (the only one I have currently is 64bit so won't work).

I emailed Rob (the creator) and he answered me that it does work in Office 2013.

I haven't been able the make it work in (my) Office 2013, so the problem still persist... for me only

Maybe Rob tried it in a multiple Office installation (as you did), maybe is that? I'll setup a Virtual Machine with a couple of Office (2010-2013) and see if it works.

 

[Jeffrey20]

Finally, I got it to work, I ran the installer as administrator and now everything works fine. I'm not sure if that was it, since I'm pretty sure I have already tried that, but at least now I can use it.

Thanks to everyone who answered the thread.

 

[Lucas79]

Thanks Jeffey!

Was looking for an answer why Excel keeps crashing on me when I put more and more code into my VBA project. Then I found out about VBA CodeCleaner, which didn't work for me either on Windows 8/Office 2013. Thanks to your little threat I was like "D'oh"... But thanks for posting your final answer, now my Excel VBA project runs perfectly again!

Greetz,

Lucas

 

[Jeffrey20]

Thanks Jeffey!

Was looking for an answer why Excel keeps crashing on me when I put more and more code into my VBA project. Then I found out about VBA CodeCleaner, which didn't work for me either on Windows 8/Office 2013. Thanks to your little threat I was like "D'oh"... But thanks for posting your final answer, now my Excel VBA project runs perfectly again!

Greetz,

Lucas

Glad my post was helpful.

 

[JoaoM]

Estoy pasando por lo mismo

En la pagina oficial, nada habla sobre Excel 2013, creo y casi seguro que es incompatibilidad con 2013.
No encuentr oforma d ehacerlo funcionar

 

[JoaoM]

Finally, I got it to work, I ran the installer as administrator and now everything works fine. I'm not sure if that was it, since I'm pretty sure I have already tried that, but at least now I can use it.

Thanks to everyone who answered the thread.

Con cual edicion lo usas? Excel 2013?

With which edition are you using it? Excel 2013?

 

[JoaoM]

I emailed Rob (the creator) and he answered me that it does work in Office 2013.

I haven't been able the make it work in (my) Office 2013, so the problem still persist... for me only

Maybe Rob tried it in a multiple Office installation (as you did), maybe is that? I'll setup a Virtual Machine with a couple of Office (2010-2013) and see if it works.

con Office 2010 si, con office 2013 NOOOOOOOOOOO

 

[Jeffrey20]

Trata así (ha funcionado todas las veces seguiendo este procedimiento):

1) Instalalo como administrador. (click derecho "ejecutar como administrador)
2) Abre Excel y mira en la barra de menús de VBE en Tools-Herramientas, fijate que no este "Clean project" o sea "que no se haya instalado bien".
3) Cierra Excel y vuelve a instalarlo (el limpiador) pero no lo desinstales antes, o sea instalalo "de nuevo, encima"...

Hacer eso ha funcionado todas las veces que he tenido que instalarlo en el 2013.

 

[JoaoM]

Si, cierto.
Lo hago tal como indicas en el
1º punto
tambien el 2º
El 3º no lo hacia pero ayer lo hice

Luego del 3º punto lo desinstale

Hoy volvi a hacerlo (instalarlo) y nada, todo igual que antes, entonces volvi a repetirlo sin desinstalarlo y sigue en nada

Sin desinstalarlo fuy a Opciones de Excel/Complementos y en Administrar selecione Complementos COM y ahí nada aparece sobre CodeCleaner, decidi Agregar, selecione la carpeta de instalacion del CodeCleaner y selecione el UNICO .dll que tiene y le di Aceptar pero nada hace, nada aparece ni nada se ve en VBA de Excel Herramientas.

Mi Office 2013 es x86

Parece no sr compatible con 2013 Su creadopr (segun lei por ahí) dice que si lo es pero no funciona ni aparece nada que diga respecto a CodCleaner