| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy module form one workbook to another
deepakmehta wrote
What i am doing is making a xl. file thrugh vba code in Main.xl and then saving it as User.xl, now i need to copy one of the modules form the Main.xl to the User.xl. Study the code on that site that looks like this: With ThisWorkbook FName = .Path & "\code.txt" ..VBProject.VBComponents("Module2").Export FName End With ActiveWorkbook.VBProject.VBComponents.Import FName Kill FName -- David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying template to workbook but user form does not copy? | Excel Programming | |||
| How do I copy a worksheet form a workbook in my workbook | Excel Programming | |||
| Run worksheet module code from workbook module? | Excel Programming | |||
| form and module | Excel Programming | |||
| Copy VBA Module and Form from Workbook to another workbook | Excel Programming | |||
Threaded Mode
