Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Organizing code in MSExcel VBA 1

Status
Not open for further replies.

oldwoodworker

Technical User
Jun 4, 2007
2
CA
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
 




Hi,

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

Skip,

[glasses] [red][/red]
[tongue]
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top