VBA - Copy paste all Modules
Hi, is there a way to programmatically copy and paste (into a text
file, say) all Subs, Functions etc from all Modules in an Excel workbook? This is so I can use this as project documentation. I have tried MZTools but can't see where I can do the above. Thanks for any pointers. |
VBA - Copy paste all Modules
You could write code to do it, but you could also do it manually quicker than
the time it would take to write the code. I archive most of mine in MS Word in Courier font, but that requires formatting and some manipulation of the text after it is pasted into Word. It would probably be easier to paste it into Notebook or a similar text file where it would retain your indents and would require minimum maniputlation. " wrote: Hi, is there a way to programmatically copy and paste (into a text file, say) all Subs, Functions etc from all Modules in an Excel workbook? This is so I can use this as project documentation. I have tried MZTools but can't see where I can do the above. Thanks for any pointers. |
All times are GMT +1. The time now is 04:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com