' - MakePremium Upgrades the client to Premium ' - SendBestWishes Sends a wishes card (why not?)
' - NewProposal clsProposal Returns a Proposal for given sales parameters ' - Proposals RW clsProposal coll A collection of clsProposal objects which represent the proposals sent in the past ' - Sales RW String Coll A collection of strings which represent sales ID numbers ' - Id R Long A cumulative Id number (attributed during initialization) The class template code generated from the above example looks as follows: 'CLIENTFILE The range selection required before running the code is shown in red. See below the example of an Excel sheet showing the class definition.
The generated code is exported in the Inmediate Window. Run subroutine Main (code provided below). Select the range containing your data (except the Class name, which will be located just above your selection). There can be as many pairs as required: column N is the variable name, column N+1 is the variable type The cells adjacent to the step 6 cells go by pairs and will provide the parameters of the member (for functions and methods only, and if relevant). The cells adjacent to the step 5 cells will provide a description of the member (optional). The cells adjacent to the step 4 cells will provide read and write attributes (if the member is a function or a method, leave blank). 
The cells adjacent (to the right) of the step 3 cells will provide the type (if the member is a method, leave blank). All the cells below will contain the name of a member of your class. Type the name of your class in one cell. Create a new sheet or chose an empty spot on a random sheet. The idea is to put the definition of your class on "paper", via an excel spreadsheet: I wanted to share this tool with the community, hopefully this is the right place. I recently developed a tool which automaticaly generates VBA code in order to smoothly create class templates.
0 kommentar(er)
