PC Review


Reply
Thread Tools Rate Thread

Deleting code comments from modules

 
 
Raj
Guest
Posts: n/a
 
      23rd Feb 2008
Hi,

While experimenting with various options, I have commented a lot of
code in various modules, Userforms, ThisWorkbook and Worksheets. I
have now finalised the code and wish to remove all comments including
the commented code. Doing this manually is a herculean task. Can I do
this programmatically?
(I can then add all the helpful comments manually)

Thanks in advance for all the help.

Regards,
Raj
 
Reply With Quote
 
 
 
 
Tim Williams
Guest
Posts: n/a
 
      23rd Feb 2008
http://www.vbaexpress.com/kb/getarticle.php?kb_id=266

Tim

"Raj" <(E-Mail Removed)> wrote in message
news:f9df49f3-8206-4b44-87aa-(E-Mail Removed)...
> Hi,
>
> While experimenting with various options, I have commented a lot of
> code in various modules, Userforms, ThisWorkbook and Worksheets. I
> have now finalised the code and wish to remove all comments including
> the commented code. Doing this manually is a herculean task. Can I do
> this programmatically?
> (I can then add all the helpful comments manually)
>
> Thanks in advance for all the help.
>
> Regards,
> Raj



 
Reply With Quote
 
Raj
Guest
Posts: n/a
 
      24th Feb 2008
On Feb 23, 6:58 am, Raj <rsp...@gmail.com> wrote:
> Hi,
>
> While experimenting with various options, I have commented a lot of
> code in various modules, Userforms, ThisWorkbook and Worksheets. I
> have now finalised the code and wish to remove all comments including
> the commented code. Doing this manually is a herculean task. Can I do
> this programmatically?
> (I can then add all the helpful comments manually)
>
> Thanks in advance for all the help.
>
> Regards,
> Raj


Hi,

I pasted the vbaexpress code in a new module, set the macro security
to allow access to VB Project and ran the code. It did not work. Is
there anything else I need to do to make this work.

TIA
Raj
 
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
List functions in modules with comments =?Utf-8?B?R2Vvcmdl?= Microsoft Access VBA Modules 2 11th Sep 2007 07:26 PM
Deleting modules in XLA ExcelMonkey Microsoft Excel Programming 2 27th Feb 2005 02:17 PM
When to code in sheet or userform modules and when to use modules Tony James Microsoft Excel Programming 1 16th Dec 2004 10:02 PM
VBA extensibility library for deleting forms, modules, code etc... =?Utf-8?B?QWppdA==?= Microsoft Excel Programming 2 19th Nov 2004 03:41 AM
RE: VBA extensibility library for deleting forms, modules, code etc... =?Utf-8?B?RnJhbmsgS2FiZWw=?= Microsoft Excel Programming 0 18th Nov 2004 07:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:05 PM.