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
.