Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Porting Modules
I am using a VBA to spawn a spreadsheet as a subset from a larger database
and would like to port a pre-coded module from the main spreadsheet into the new, spawned one. Does anyone know how I can copy modules wholesale using VBA into a new spreadsheet? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Porting Modules
Have a look at this link...
http://www.cpearson.com/excel/vbe.htm -- HTH... Jim Thomlinson "Mel Monroe" wrote: I am using a VBA to spawn a spreadsheet as a subset from a larger database and would like to port a pre-coded module from the main spreadsheet into the new, spawned one. Does anyone know how I can copy modules wholesale using VBA into a new spreadsheet? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Porting Modules
Apart from copying the module in - see http://www.cpearson.com/excel/vbe.htm
You might also consider creating a template file with the required code already in it. Just open the template,drop your data in and save it with the required name. This assumes you want the same code and structure each time for different data sets. -- Cheers Nigel "Mel Monroe" wrote in message ... I am using a VBA to spawn a spreadsheet as a subset from a larger database and would like to port a pre-coded module from the main spreadsheet into the new, spawned one. Does anyone know how I can copy modules wholesale using VBA into a new spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic question - modules and class modules - what's the difference? | Excel Programming | |||
When to code in sheet or userform modules and when to use modules | Excel Programming | |||
VBA Script Porting | Excel Programming | |||
Porting VBA Libraries | Excel Programming | |||
Porting 16-bit to 32-bit | Excel Programming |