Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-20-2015, 04:28 PM
Dave T Dave T is offline Extract VBA code to save in Word document Windows 7 64bit Extract VBA code to save in Word document Office 2007
Advanced Beginner
Extract VBA code to save in Word document
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract VBA code to save in Word document VBA Code for clean all data from ms word document egyp7 Word VBA 4 05-16-2014 03:59 PM
Extract form fields to Word Document RonNCmale Word VBA 22 01-11-2014 05:06 AM
Word ask to save template whenever i save a derived document jorbjo Word 3 10-04-2012 10:52 AM
Extract VBA code to save in Word document VBA code to extract specific bookmarks from multiple word files Rattykins Word VBA 4 06-27-2012 10:02 PM
Extract Numbers from Zip Code Karen615 Excel 3 09-21-2011 06:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft