How to copy VBA project (macros) from one workbook to another
workbook(create exact copy)? Please show in detail.
thanks
How to copy VBA project (macros) from one workbook to another
workbook(create exact copy)? Please show in detail.
thanks
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" <[email protected]> wrote in message
news:[email protected]...
> How to copy VBA project (macros) from one workbook to another
> workbook(create exact copy)? Please show in detail.
>
> thanks
>
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
>
>
>.
>
<[email protected]> wrote in message
news:[email protected]...
> 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.
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-----
>
><[email protected]> wrote in message
>news:[email protected]...
>> 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.
>
>
>.
>
"cubus" <[email protected]> wrote in message
news:%[email protected]...
>
> Some note: I want *all* VBA content of given workbook to be copied, not
just
> separate modules.
>
Not designed to encourage further help!
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> "cubus" <[email protected]> wrote in message
> news:%[email protected]...
>>
>> 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?
Your answer sounded like it was complaining about the advice offered ...
Some note:
"cubus" <[email protected]> wrote in message
news:[email protected]...
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > "cubus" <[email protected]> wrote in message
> > news:%[email protected]...
> >>
> >> 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?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks