Removing comments from VBA code

[TheRobster]

Is there a quick way to remove all the comments from VBA code in Excel? I have an application with a lot of code in modules, forms, etc and want to remove all the comments. I could go through it all manually and do it but it would obviously be much easier if there was a way to get the computer to do it for me.

Thanks
-Rob

[RobDog888]

Check out this thread. It may not remove the comments, but it will document
them. To remove them you would have to read every line in all modules,
classes, and parse out the lines with the apostrophies in them.

Alos, check out my code in CodeBank to access and enumerate vba macro
code from VB.

HTH