Copying modules

[Steven Revell]

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

 

[Ron de Bruin]

Check out
http://www.cpearson.com/excel/vbe.htm

 

[Tom Ogilvy]

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.