Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strip Modules from Workbook - Code Organization
I've got an Excel workbook with a few thousand lines of VBA code in 10 or so
Modules. This workbook get's saved as specific jobs, so the code is also saved in multiple files. I'm constantly revising the code, so I have a current version and older versions. I'd like to strip multiple modules out a workbook, so I don't accidently use older code. Anyone know of a Sub or 3rd party app that can do this, without having to remove each Module manually (i.e. RMC - Remove <module - N)? Would it be better to keep the VBA code in a separate workbook - i.e. file #1 contains the spreadsheet data, file #2 contains code only? Suggestions appreciated, Don |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Strip Modules from Workbook - Code Organization
Check out Chip's site Don
http://www.cpearson.com/excel/vbe.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Don L" wrote in message ... I've got an Excel workbook with a few thousand lines of VBA code in 10 or so Modules. This workbook get's saved as specific jobs, so the code is also saved in multiple files. I'm constantly revising the code, so I have a current version and older versions. I'd like to strip multiple modules out a workbook, so I don't accidently use older code. Anyone know of a Sub or 3rd party app that can do this, without having to remove each Module manually (i.e. RMC - Remove <module - N)? Would it be better to keep the VBA code in a separate workbook - i.e. file #1 contains the spreadsheet data, file #2 contains code only? Suggestions appreciated, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Where 2 place the code? (Worksheet Codes Vs. Modules) | Excel Discussion (Misc queries) | |||
Strip workbook of macros, VBA, MS Query, etc. | Excel Discussion (Misc queries) | |||
Delete Code Modules Programatically | Excel Discussion (Misc queries) | |||
code to strip back (from the right) a directory but not the file name | Excel Programming | |||
Scope of variable includes all Form _and_ Code modules?? | Excel Programming |