Removing comments from VBA code

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

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