Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I define a macro that will generate VBA code?
Hi,
What I basically want to do is to press a button and have a new worksheet created and for that worksheet to have a ready-made set of subroutines pre-defined by me. Coming from a Java background, I'm used to defining a Class in which there are various subroutines and then calling a constructor method to create an instance of that class containing all the little subroutines etc. I haven't had much luck in finding any microsoft tutorials - can anyone help me out? Many thanks in advance! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I define a macro that will generate VBA code?
Set up a workbook with one sheet which already has all the routines in them
and save it as a template (extension is .xlt and is saved as a file type of Template). When you want a new one created, use this template instead of a new worksheet. If you name it "sheet.xlt" and store it in the xlstart directory, it will be the default for all new sheets created( including the code) "I believe" <I wrote in message ... Hi, What I basically want to do is to press a button and have a new worksheet created and for that worksheet to have a ready-made set of subroutines pre-defined by me. Coming from a Java background, I'm used to defining a Class in which there are various subroutines and then calling a constructor method to create an instance of that class containing all the little subroutines etc. I haven't had much luck in finding any microsoft tutorials - can anyone help me out? Many thanks in advance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Generate sequential numbers with define format. | Excel Worksheet Functions | |||
Need VBA Code to Let User Define Active Sheet | Excel Discussion (Misc queries) | |||
Looking for code to define a range | Excel Discussion (Misc queries) | |||
VBA code to define nbr of text character a a cell/column | Excel Programming | |||
VB code to generate an e-mail with an EXCEL attachment, but not se | Excel Programming |