View Single Post
 
Old 01-20-2015, 04:28 PM
Dave T Dave T is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default Extract VBA code to save in Word document

Hello All,

This is my first post on this site...

Currently I am using Word 2007 and I keep all of my macros in an add-in.
I know that you can export modules as .bas files but I am wondering if there is any macro or third party product that can extract ALL of the VBA code from all of my modules, forms, etc. and export it as text to a Word document.

Currently I keep all of my useful macros in a Word document that is formatted using code from the VB Helper site called Use VBA macros to format text in Word to look like code (http://www.vb-helper.com/howto_format_code_in_word.html).

I prefer to keep the macros I use the most in a Word document so that I can print it and refer to it without sitting in front of a computer.

An agricultural approach could be is when I am within Visual Basic I could go to File > Print > Current Project using Adobe PDF as the output and then copying the text from this to paste in my Word document.

Any other suggestions would be appreciated.

Regards,
Dave T
Reply With Quote