Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to copy VBA project?
How to copy VBA project (macros) from one workbook to another
workbook(create exact copy)? Please show in detail. thanks |
#2
|
|||
|
|||
hi
open both workbooks in the VBE window display the project explorer click on the module that you want to copy to the other workbook in the project explorer drag it to the workbook name and let the mouse go the module will be copied there. Cheers JulieD "cubus" wrote in message ... How to copy VBA project (macros) from one workbook to another workbook(create exact copy)? Please show in detail. thanks |
#3
|
|||
|
|||
hi.
open the vb editor Alt+F11 in the left pane (vb projects), right click the project you wish to export. (expand the trees if neccessary.) click export on the popup menu. The project will be exported as a .bas file(text). default destination will be office directory. to import to another file, open the file. open the vb editor. right click the file name in the vb project pane (left). click import on the popup menu. -----Original Message----- How to copy VBA project (macros) from one workbook to another workbook(create exact copy)? Please show in detail. thanks . |
#4
|
|||
|
|||
wrote in message ... hi. open the vb editor Alt+F11 in the left pane (vb projects), right click the project you wish to export. (expand the trees if neccessary.) click export on the popup menu. The project will be exported as a .bas file(text). default destination will be office directory. to import to another file, open the file. open the vb editor. right click the file name in the vb project pane (left). click import on the popup menu. -----Original Message----- How to copy VBA project (macros) from one workbook to another workbook(create exact copy)? Please show in detail. thanks Some note: I want *all* VBA content of given workbook to be copied, not just separate modules. |
#5
|
|||
|
|||
hi again,
If that be the case, it may be easier to copy the WB to a new name and delete the data from the new WB. The way i discribed is for 1 project at a time. JulieD has a good idea too. -----Original Message----- wrote in message ... hi. open the vb editor Alt+F11 in the left pane (vb projects), right click the project you wish to export. (expand the trees if neccessary.) click export on the popup menu. The project will be exported as a .bas file(text). default destination will be office directory. to import to another file, open the file. open the vb editor. right click the file name in the vb project pane (left). click import on the popup menu. -----Original Message----- How to copy VBA project (macros) from one workbook to another workbook(create exact copy)? Please show in detail. thanks Some note: I want *all* VBA content of given workbook to be copied, not just separate modules. . |
#6
|
|||
|
|||
"cubus" wrote in message
... Some note: I want *all* VBA content of given workbook to be copied, not just separate modules. Not designed to encourage further help! |
#7
|
|||
|
|||
"Bob Phillips" wrote in message ... "cubus" wrote in message ... Some note: I want *all* VBA content of given workbook to be copied, not just separate modules. Not designed to encourage further help! Not clear. What do you mean? |
#8
|
|||
|
|||
Your answer sounded like it was complaining about the advice offered ...
Some note: "cubus" wrote in message ... "Bob Phillips" wrote in message ... "cubus" wrote in message ... Some note: I want *all* VBA content of given workbook to be copied, not just separate modules. Not designed to encourage further help! Not clear. What do you mean? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy in filter mode | Excel Worksheet Functions | |||
Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Copy worksheet with Pivot Table and break link to original workshe | Excel Worksheet Functions |