| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy module form one workbook to another
Hi, How do i copy modules form one workbook to another through vba. Regards, Deepak -- deepakmehta ------------------------------------------------------------------------ deepakmehta's Profile: http://www.excelforum.com/member.php...o&userid=29609 View this thread: http://www.excelforum.com/showthread...hreadid=539876 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy module form one workbook to another
Check out Chip Pearson's site:
http://cpearson.com/excel/vbe.htm deepakmehta wrote: Hi, How do i copy modules form one workbook to another through vba. Regards, Deepak -- deepakmehta ------------------------------------------------------------------------ deepakmehta's Profile: http://www.excelforum.com/member.php...o&userid=29609 View this thread: http://www.excelforum.com/showthread...hreadid=539876 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy module form one workbook to another
I have tried that but i am still unsuccessful...... help !! 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. Regards, Deepak -- deepakmehta ------------------------------------------------------------------------ deepakmehta's Profile: http://www.excelforum.com/member.php...o&userid=29609 View this thread: http://www.excelforum.com/showthread...hreadid=539876 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to copy module form one workbook to another
Store your code as .bas files and use the procedures at Chip's site to import
them. deepakmehta wrote: I have tried that but i am still unsuccessful...... help !! 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. Regards, Deepak -- deepakmehta ------------------------------------------------------------------------ deepakmehta's Profile: http://www.excelforum.com/member.php...o&userid=29609 View this thread: http://www.excelforum.com/showthread...hreadid=539876 -- Dave Peterson |
|
#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 |
| Reply |
| 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 | |||
![deepakmehta[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
