Manually in the VBE - right click the module and choose Export. Save in the
desired location. In the target workbook, within the VBE right click the
VBAProject and choose import file.

--
Cheers
Nigel



"gabch" wrote in
message ...

Dear all,

If I write VBA codes and store in Module.
How can I copy the whole Module to new workbook through VBA?

Best regards


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=535389