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
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