Modules to Text. Help.

[thebernieb]

I'm looking for a way to send all modules to a text file. I can accomplish this pretty easily with documents container for stand-alone modules, but class modules are a different issue. Any suggestions?

Also, anyone know of any programs that format VB code from text files to MS Word or HTML with color and indents? I've been thinking of writing an MS Word module to do this, but really don't feel like spending the time. Let me know.

Thanks,
Bernie

 

[Store300]

You can try something along the lines of:

For each x in Activeworkbook.VBProject.VBComponents
y = x.Name
z = "C:\" & y & ".txt"
x.export z
Next x

This will catch modules, classes & worksheet objects
Store300

Store300@ftnetwork.com