Export the module, then import would probably be the easiest.

http://www.cpeason.com/excel/vbe.htm

at Chip Pearson's site should give you the basics.

--
Regards,
Tom Ogilvy

"Steven Revell" wrote in message
...
Hi,

I was wondering if anyone knew how to programmatically
copy a module from one open workbook to another open
workbook.

Thanks in advance for any help.

Steven