oldwoodworker
Technical User
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
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