Move an Excel macro to another Excel file
 

Hi all,

I've written a macro inside an Excel file. However, since I want to
give it to not so expert users, I would be happy to add something like
a button capable of "copy" all the macros (the part present in "This
work book", Forms and Modules) into the desired excel file. I know
that this can be done handly (with the export function), but I would
like to know if it can be achieved with "some lines of code".

Thanks,
David

Move an Excel macro to another Excel file
 

hi,
not sure if it will help you but this site has some stuff
on manipulating code with code.
http://www.cpearson.com/excel/vbe.htm

-----Original Message-----
Hi all,

I've written a macro inside an Excel file. However, since
I want to
give it to not so expert users, I would be happy to add
something like
a button capable of "copy" all the macros (the part
present in "This
work book", Forms and Modules) into the desired excel
file. I know
that this can be done handly (with the export function),
but I would
like to know if it can be achieved with "some lines of
code".

Thanks,
David
.

Move an Excel macro to another Excel file
 

Thank you "anonymous" very much.

The linked site should work perfectly.

Bye,
David


wrote in message ...
hi,
not sure if it will help you but this site has some stuff
on manipulating code with code.
http://www.cpearson.com/excel/vbe.htm