PC Review


Reply
Thread Tools Rate Thread

Code Cleaner for PowerPoint?

 
 
Jenny
Guest
Posts: n/a
 
      6th Jul 2005
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


 
Reply With Quote
 
 
 
 
Steve Rindsberg
Guest
Posts: n/a
 
      7th Jul 2005
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
================================================


 
Reply With Quote
 
Jenny
Guest
Posts: n/a
 
      7th Jul 2005

"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.


 
Reply With Quote
 
Brian Reilly, MS MVP
Guest
Posts: n/a
 
      7th Jul 2005
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.
>


 
Reply With Quote
 
Jenny
Guest
Posts: n/a
 
      8th Jul 2005
"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


 
Reply With Quote
 
Brian Reilly, MS MVP
Guest
Posts: n/a
 
      8th Jul 2005
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
>


 
Reply With Quote
 
Steve Rindsberg
Guest
Posts: n/a
 
      8th Jul 2005

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
================================================


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a cleaner way to code this rodchar Microsoft C# .NET 9 13th Aug 2008 07:56 PM
Code cleaner WH99 Microsoft Excel Misc 7 18th Jul 2008 09:15 PM
code cleaner jamie.cutting@mouchelparkman.com Microsoft Excel Programming 1 23rd Apr 2007 02:20 PM
VBA Code Cleaner Tweety Microsoft Word Document Management 1 17th Jun 2004 01:31 PM
VB Code Cleaner Tim Childs Microsoft Excel Programming 2 4th Dec 2003 04:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:16 PM.