4 Attachment(s)
Class for saving/loading UDTs (User defined types)
I made Class that has Save/Load functions for UDT arrays. And Get/Let Properties with the same name(s) as the user-type...
I made it as copy/paste-able as possible, for adding/removing user-types to class code.
With VBA you can programmatically create code. So I made a Class that automatically creates the UDT SAVE/LOAD Class with functions for all the custom user-types. That way you don't have to manually edit UDT-SAVE/LOAD Class every time you add or remove a user-type.
Attached is the code.
- makeUDTtool.cls : Class for creating UDT save/load class
- Module_demo_4_UDTtool.bas : routines for creating and using UDT save/load class
- new1_UDTTools.cls : for reference, should not need to import
- new2_UDTTools.cls : for reference, should not need to import
- Import the makeUDTTool class
- Import the Module_demo_4_UDTtool module
- Run the udtTool_maker_demo routine
newX_UDTTools Class(s) should be created
- Run the udtTool_SaveLoad_demo routine
Shows how the newly created new2_UDTTools Class is used.
Re: Class for saving/loading UDTs (User defined types)
That should be a CodeBank post....except that it looks like we don't have a CodeBank for Office specifically, and there doesn't look to be any other obvious CodeBank place to put it.
Re: Class for saving/loading UDTs (User defined types)
I got more universal Excel-VBA code.
A Calendar tool, so you don't have to use Active-X
A library of String tools.