Hello,
Can I copy code objects - Classes, Moduls and "ThisWorkBook" - into another
WorkBook?

Tnx in advance

open both workbooks ... the same excel app is fine but two excel app is ok
too.
go to the development environment and just drag/drop the modules from one
workbook to the other. copy is the default.


"E.Z." <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
> Can I copy code objects - Classes, Moduls and "ThisWorkBook" - into
> another WorkBook?
>
> Tnx in advance
>
>

Its not what I want. I need a way to do it from my app.
Somthing like what Worksheet.Copy does.

"Patrick Molloy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> open both workbooks ... the same excel app is fine but two excel app is ok
> too.
> go to the development environment and just drag/drop the modules from one
> workbook to the other. copy is the default.
>
>
> "E.Z." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hello,
>> Can I copy code objects - Classes, Moduls and "ThisWorkBook" - into
>> another WorkBook?
>>
>> Tnx in advance
>>
>>
>

See Chip Pearson webpage

http://www.cpearson.com/Excel/vbe.aspx

"E.Z." wrote:

> Its not what I want. I need a way to do it from my app.
> Somthing like what Worksheet.Copy does.
>
> "Patrick Molloy" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > open both workbooks ... the same excel app is fine but two excel app is ok
> > too.
> > go to the development environment and just drag/drop the modules from one
> > workbook to the other. copy is the default.
> >
> >
> > "E.Z." <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> Hello,
> >> Can I copy code objects - Classes, Moduls and "ThisWorkBook" - into
> >> another WorkBook?
> >>
> >> Tnx in advance
> >>
> >>
> >
>
>
>

Yup, tnx

"Joel" <(E-Mail Removed)> wrote in message
news:6134910B-D2F1-4019-8EF1-(E-Mail Removed)...
> See Chip Pearson webpage
>
> http://www.cpearson.com/Excel/vbe.aspx
>
> "E.Z." wrote:
>
>> Its not what I want. I need a way to do it from my app.
>> Somthing like what Worksheet.Copy does.
>>
>> "Patrick Molloy" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > open both workbooks ... the same excel app is fine but two excel app is
>> > ok
>> > too.
>> > go to the development environment and just drag/drop the modules from
>> > one
>> > workbook to the other. copy is the default.
>> >
>> >
>> > "E.Z." <(E-Mail Removed)> wrote in message
>> > news:(E-Mail Removed)...
>> >> Hello,
>> >> Can I copy code objects - Classes, Moduls and "ThisWorkBook" - into
>> >> another WorkBook?
>> >>
>> >> Tnx in advance
>> >>
>> >>
>> >
>>
>>
>>