Organizing code in MSExcel VBA 1

[oldwoodworker]

I use Excel and Excel VBA in a CAD environment.

Each furmiture project is modeled in an Excel workbook which stores coordinate data. A VBA module in that workbook manipulates the data into a script. This script drives my CAD program, currently Rhino 4.

As you can imagine this has generated many scriptwritng procedures (drawPolyline, extrudePolyline, dimensionFront, etc.) which I cut and paste into the new module for every new project.

Can I tuck these procedures somewhere (create a library) so they load when Excel loads and are simply called from the new module being created for each project? Is this what a class module is supposed to do?

Thanks for any help and excuse the very basic (ugh) question

Pat

 

[SkipVought]

Hi,

Why not in your PERSONAL.XLS workbook. I have scores of personally written functions that are always at my beck and call.

Skip,

_[red][/red]

 

[oldwoodworker]

Thanks Skip. That sounds like a good approach. I'll start rounding them up (and maybe clean up some sloppy scope and visibility issues at the same time).

Pat