Old code in Excel add-in (.xla)?

[Yarik]

Hello everyone,

We have a couple of Excel 2000 add-ins under maintenance. It looks like
the .xla file contains scraps of old code (i.e. code fragments that are
no longer there and cannot be found using VBA's
search-across-entire-project function). For example, I can see old
names of some functions and string literals that are no longer used.

Is there any easy way to get rid of all traces of old code? (I mean,
something easier than creating an add-in from scratch and
exporting/importing code from the old version to the new one.)

FWIW: I already tried "VBA Code Cleaner" by AppsPro
(http://www.appspro.com/Utilities/CodeCleaner.htm), and it did remove
something from the XLA file in question, but those pesky shreds of old
code still remain in the file...

Thank you,
Yarik.

 

[NickHK]

Yarik,
http://www.mztools.com/index.htm

This may help you identify obsolete code.

NickHK

 

[Yarik]

Hi Nick,

This is a very interesting product you've pointed me to, but... If you
meant that I should try its "Find Text" feature, then the question is:
Is MZTools capable to search in places that are not accessible by VBA's
IDE standard search function? If it is, then how could I _edit_ the
code that is not accessible in the VBA IDE itself?

Thanks,
Yarik.

P.S. In any case, the product is really very intriguing. I just might
give it a try regardless of whether it can help me with the specific
problem in question...

 

[NickHK]

Yarik,
You mean you have the older macro sheet style code in your workbooks ?

NickHK

 

[Jim Rech]

Get Rob Bovey's Code Cleaner:

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

--
Jim
| Hi Nick,
|
| This is a very interesting product you've pointed me to, but... If you
| meant that I should try its "Find Text" feature, then the question is:
| Is MZTools capable to search in places that are not accessible by VBA's
| IDE standard search function? If it is, then how could I _edit_ the
| code that is not accessible in the VBA IDE itself?
|
| Thanks,
| Yarik.
|
| P.S. In any case, the product is really very intriguing. I just might
| give it a try regardless of whether it can help me with the specific
| problem in question...
|
|
| NickHK wrote:
| > Yarik,
| > http://www.mztools.com/index.htm
| >
| > This may help you identify obsolete code.
| >
| > NickHK
|