Anyone know where I can get something for PowerPoint similar to, what we
have in Excel, called "CodeCleaner"? It's a macro someone made that, among
other things, has an option to clean comments from VBE modules.

Anyone know what I'm talking about?

Thank you,
Jenny

In article <qOYye.46560$(E-Mail Removed)>, Jenny wrote:
> Anyone know where I can get something for PowerPoint similar to, what we
> have in Excel, called "CodeCleaner"? It's a macro someone made that, among
> other things, has an option to clean comments from VBE modules.
>
> Anyone know what I'm talking about?

As I recall, the VBA for CodeCleaner (or something similar) isn't protected.
I'm playing with converting it to PPT off and on but haven't gotten all that
far. You might have a go with it.

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

"Steve Rindsberg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In article <qOYye.46560$(E-Mail Removed)>, Jenny wrote:
>> Anyone know where I can get something for PowerPoint similar to, what we
>> have in Excel, called "CodeCleaner"? It's a macro someone made that,
>> among
>> other things, has an option to clean comments from VBE modules.
>>
>> Anyone know what I'm talking about?
>
> As I recall, the VBA for CodeCleaner (or something similar) isn't
> protected.
> I'm playing with converting it to PPT off and on but haven't gotten all
> that
> far. You might have a go with it.

I think I will. The aspect of CodeCleaner I need most urgently seems to be
the simplest, luckily. I need a routine to strip the comments from my code
and align it left and remove blank lines. Peeking at CodeCleaner it looks
like a module is devoted to just that and it's highly commented. I think I
may be able to figure it out. I'll let you know if I do.

Jenny,
Rob Bovey, an Excel MVP, wrote Code Cleaner.

You could just export your PPT modules to files and import them into
an XL workbook and run Code Cleaner, then export those guys and import
them into PPT.

Brian Reilly, PowerPoint MVP

On Wed, 6 Jul 2005 22:21:07 -0500, "Jenny" <(E-Mail Removed)> wrote:

>
>"Steve Rindsberg" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> In article <qOYye.46560$(E-Mail Removed)>, Jenny wrote:
>>> Anyone know where I can get something for PowerPoint similar to, what we
>>> have in Excel, called "CodeCleaner"? It's a macro someone made that,
>>> among
>>> other things, has an option to clean comments from VBE modules.
>>>
>>> Anyone know what I'm talking about?
>>
>> As I recall, the VBA for CodeCleaner (or something similar) isn't
>> protected.
>> I'm playing with converting it to PPT off and on but haven't gotten all
>> that
>> far. You might have a go with it.
>
>I think I will. The aspect of CodeCleaner I need most urgently seems to be
>the simplest, luckily. I need a routine to strip the comments from my code
>and align it left and remove blank lines. Peeking at CodeCleaner it looks
>like a module is devoted to just that and it's highly commented. I think I
>may be able to figure it out. I'll let you know if I do.
>

"Brian Reilly, MS MVP" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Jenny,
> Rob Bovey, an Excel MVP, wrote Code Cleaner.
>
> You could just export your PPT modules to files and import them into
> an XL workbook and run Code Cleaner, then export those guys and import
> them into PPT.
>
> Brian Reilly, PowerPoint MVP

Brian,

You're so smart! Thank you for suggesting that. It worked wonderfully. I
think I can even automate the import/export process with code.

Jenny

Jenny,
I'm not the smart one. It's that Rob Bovey guy who is the smart one.
He suggested that trick a while back (g).
Brian Reilly, PowerPoint MVP

On Thu, 7 Jul 2005 21:33:06 -0500, "Jenny" <(E-Mail Removed)> wrote:

>"Brian Reilly, MS MVP" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> Jenny,
>> Rob Bovey, an Excel MVP, wrote Code Cleaner.
>>
>> You could just export your PPT modules to files and import them into
>> an XL workbook and run Code Cleaner, then export those guys and import
>> them into PPT.
>>
>> Brian Reilly, PowerPoint MVP
>
>Brian,
>
>You're so smart! Thank you for suggesting that. It worked wonderfully. I
>think I can even automate the import/export process with code.
>
>Jenny
>

Darn it, Brian! Here I thought I had Jenny conned into doing the PPT version
of code cleaner and you had to step into it ...

Tsk.

(Jenny, sorry I didn't remember that trick of Brian's. Heaven knows he's
beaten me over the head with it often enough. Skull's just not porous enough
for it to percolate through, I guess)

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================