PDA

View Full Version : Module management questions



Joe Daddy
11-07-2006, 10:57 AM
I have several sets of analysis macros that I have organized into what I believe are called projects. To 'backup' this project, I export each module from the GUI to a specific directory. To move or restore this code, I then import from the GUI into the next document. Since the project has 8 modules for code separation and management, it is an error plagued process.

This poses a couple of questions for me:

1. How can I write some simple vba code that does something like"

backup this project to c:\directory ?
backup module1 to c:\directory ?
load module1 to this spreadsheet

2. What code management software is outhere that is worth the time to learn. I found one that had no documentation and for the life of me I could not figure it out.

3. Are their code troubleshooters and code structure clean up programs?

Thanks for your assistance in advance.


Joe Daddy

lucas
11-07-2006, 11:03 AM
Hi Joe,
I would suggest you make an addin out of your modules. Its not hard to do and your modules can be available to all spreadsheets you open and you can simply back up the addin. You can even include a menu to run your routines.

The only problem would be if you need to add your routines to excel files to send to others....that don't have the addin.

Bob Phillips
11-07-2006, 11:40 AM
Why not just backup the workbook?

Joe Daddy
11-08-2006, 06:04 PM
Why not just backup the workbook?

XLD, Based upon your answering my question with this question, well, we are in very different places. I'll not bore you with an explanation.

Joe Daddy
11-08-2006, 06:13 PM
Hi Joe,
I would suggest you make an addin out of your modules.

Lucas,
Thank you very much for this great piece of advice. I have made add-ins before.

I found out how to export, import and remove modules from vba from this website:
w w w cpearson.com/excel/vbe.htm

Both Pearson's techniques and your advice on using an Add-in are most valuable.


That takes care of question 1 how about questions 2 and 3?


Best!

SamT
11-08-2006, 06:40 PM
Joe Daddy,
Talk about Deja Vu all over again. . .
Just this morning I was looking at the VBE Object Model.

Look up CodePane and CodeModule in the help files.

SamT