ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Code cleaner (https://www.excelbanter.com/excel-discussion-misc-queries/195399-code-cleaner.html)

WH99

Code cleaner
 
How can I download a code cleaner for excel?
--
WH99

Ron de Bruin

Code cleaner
 
Go to
http://www.appspro.com/Utilities/CodeCleaner.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"WH99" wrote in message ...
How can I download a code cleaner for excel?
--
WH99


Don Guillett

Code cleaner
 
http://www.appspro.com/Utilities/CodeCleaner.htm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WH99" wrote in message
...
How can I download a code cleaner for excel?
--
WH99



Bob Phillips[_3_]

Code cleaner
 
Depends upon what you mean by a code cleaner.

If you mean a utility that exports all modules and re-imports them, thereby
reducing file-bloat which can in extreme cases cause runtime errors, then
Ron has given you the answer.

If you want a utility that will tidy up your code, remove unused variables,
and/or other things, there are a few around that do various things, but no
one-stop shop.

--
__________________________________
HTH

Bob

"WH99" wrote in message
...
How can I download a code cleaner for excel?
--
WH99




WH99

Code cleaner
 
Thanks Bob,
I keep getting and warning that excel that it has encounted a problem and
will have to close down. Iv got a large userform code and I was hoping that a
code cleaner would sort the problem out!
I guess I have to go through the whole code bit by bit and see if there are
any obvious errors
WH99


"Bob Phillips" wrote:

Depends upon what you mean by a code cleaner.

If you mean a utility that exports all modules and re-imports them, thereby
reducing file-bloat which can in extreme cases cause runtime errors, then
Ron has given you the answer.

If you want a utility that will tidy up your code, remove unused variables,
and/or other things, there are a few around that do various things, but no
one-stop shop.

--
__________________________________
HTH

Bob

"WH99" wrote in message
...
How can I download a code cleaner for excel?
--
WH99





Gord Dibben

Code cleaner
 
Rob Bovey has a free add-in

http://www.appspro.com/Utilities/Utilities.htm


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 07:38:11 -0700, WH99 wrote:

How can I download a code cleaner for excel?



WH99

Code cleaner
 
Thanks very much all.
--
WH99


"Gord Dibben" wrote:

Rob Bovey has a free add-in

http://www.appspro.com/Utilities/Utilities.htm


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 07:38:11 -0700, WH99 wrote:

How can I download a code cleaner for excel?




Bob Phillips[_3_]

Code cleaner
 
Try the link Ron gave you first.

--
__________________________________
HTH

Bob

"WH99" wrote in message
...
Thanks Bob,
I keep getting and warning that excel that it has encounted a problem and
will have to close down. Iv got a large userform code and I was hoping
that a
code cleaner would sort the problem out!
I guess I have to go through the whole code bit by bit and see if there
are
any obvious errors
WH99


"Bob Phillips" wrote:

Depends upon what you mean by a code cleaner.

If you mean a utility that exports all modules and re-imports them,
thereby
reducing file-bloat which can in extreme cases cause runtime errors, then
Ron has given you the answer.

If you want a utility that will tidy up your code, remove unused
variables,
and/or other things, there are a few around that do various things, but
no
one-stop shop.

--
__________________________________
HTH

Bob

"WH99" wrote in message
...
How can I download a code cleaner for excel?
--
WH99








All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com