Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
Is there are code that would allow me to list all codes within a
workbook? I need all of the actual codes (sub, private subs, worksheet/workbook change events, etc). I found several that just lists names of them all. However, I want the entire code. I am trying to create a backup list of all of my codes that i've gathered, solicited, and or created over the years from various workbooks. Perhaps copying them directly to word or notepad would be a good option. Thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
In the VBA editor - use File - Print and set options as required!
-- Regards, Nigel "J.W. Aldridge" wrote in message ... Is there are code that would allow me to list all codes within a workbook? I need all of the actual codes (sub, private subs, worksheet/workbook change events, etc). I found several that just lists names of them all. However, I want the entire code. I am trying to create a backup list of all of my codes that i've gathered, solicited, and or created over the years from various workbooks. Perhaps copying them directly to word or notepad would be a good option. Thanx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
Why not just export the modules into a library folder on your harddrive???
J.W. Aldridge wrote: Is there are code that would allow me to list all codes within a workbook? I need all of the actual codes (sub, private subs, worksheet/workbook change events, etc). I found several that just lists names of them all. However, I want the entire code. I am trying to create a backup list of all of my codes that i've gathered, solicited, and or created over the years from various workbooks. Perhaps copying them directly to word or notepad would be a good option. Thanx |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
Charlotte,
If you have details on how to, I'd try it. Thanx Nigel, That gets me off the ground. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
If you copy them to Word, I suggest doing it in plain text, otherwise you
will have a big formatting problem to get your indents and line wraps straightened out. If you copy to Notepad, the indents are pretty much maintained but line wrap can also be a pain there. I saw some code somewhere that copied the main module procedures, but I don't recall seeing any that would pick up forms' and controls' underlying codes. It doesn't take that long to copy anyhow. Useer forms and controls will take the most time. The project module and sheet modules are a snap. "J.W. Aldridge" wrote: Is there are code that would allow me to list all codes within a workbook? I need all of the actual codes (sub, private subs, worksheet/workbook change events, etc). I found several that just lists names of them all. However, I want the entire code. I am trying to create a backup list of all of my codes that i've gathered, solicited, and or created over the years from various workbooks. Perhaps copying them directly to word or notepad would be a good option. Thanx |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
Charlotte Wrote: Why not just export the modules into a library folder on your harddrive??? J.W. Wrote: Charlotte, If you have details on how to, I'd try it. If you use 'VBA Code Cleaner' (http://www.appspro.com/Utilities/CodeCleaner.htm), it will save all the modules in a file you specify. You can open them in Notepad (or anything else) and print them. And you get your VBA project cleaned in the process. Remember to set a fixed-pitch font before printing. -- shg ------------------------------------------------------------------------ shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=25598 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all code in workbook?
Just right-click on a Module, and 'Export'
This will save the VBA code as a simple text-file with the suffix .BAS. CE J.W. Aldridge wrote: Charlotte, If you have details on how to, I'd try it. Thanx Nigel, That gets me off the ground. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB Code to List all Sheets and Charts in a Workbook | Excel Programming | |||
Code to automatically sort a list, each time that a new entry isadded to the bottom of the list | Excel Programming | |||
Code to change code in a sheet and workbook module | Excel Programming | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Code to Advance filter a list in a shared workbook | Excel Programming |