ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying modules (https://www.excelbanter.com/excel-programming/277871-copying-modules.html)

Steven Revell

Copying modules
 
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

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



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"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




Tom Ogilvy

Copying modules
 
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





All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com