Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create New Workbook and add VBA Code to using VBA
I have and excel workbook that uses VBA to create another workbook.
There is also some vba code that I would like included in the new workbook. What is the best way to achieve that? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create New Workbook and add VBA Code to using VBA
You can use code to create and modify other code by using the objects and
methods that are part of the Extensibility library. See www.cpearson.com/Excel/VBE.aspx for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Rligouri" wrote in message oups.com... I have and excel workbook that uses VBA to create another workbook. There is also some vba code that I would like included in the new workbook. What is the best way to achieve that? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create New Workbook and add VBA Code to using VBA
I think I would create a template workbook (*.xlt) and use that as a basis for
the new workbook. Then I'd use something like: Dim NewWkbk as workbook set newwkbk = workbooks.add(template:="C:\yourtemplate.xlt") I think you'll find that life is lots easier if you don't have to worry about security settings and importing the code (or copying from one workbook to another). But if you want to try this, check out Chip Pearson's site: http://cpearson.com/excel/vbe.aspx Rligouri wrote: I have and excel workbook that uses VBA to create another workbook. There is also some vba code that I would like included in the new workbook. What is the best way to achieve that? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Taking specific rows from on workbook to create another workbook | Excel Worksheet Functions | |||
How to create a form to insert a hyerlink.VBA code to create a for | Excel Discussion (Misc queries) | |||
VBA code to create "variable" worksheets within a workbook | Excel Programming | |||
run code on opening workbook and apply code to certain sheets | Excel Programming | |||
Create a newworksheet with VBA code and put VBA code in the new worksheet module | Excel Programming |