Import module with vba
 

Is there a way to have vba code import an exported module or form into
workbook? I am designing a program (from within Excel) that builds
workbook and it needs to add forms and modules to the new workbook.

tia
Bria

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Import module with vba
 

Thanks. Exactly what I was looking for.

Brian :

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Import module with vba
 

Search for 'Copying Modules Between Projects' on Chip Pearson's
WebPage.

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

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Is there a way to have vba code import an exported module or form into a
workbook? I am designing a program (from within Excel) that builds a
workbook and it needs to add forms and modules to the new workbook.

tia
Brian