Automized Code-Creation

[Peter Plumber]

Hi,

is there a way to add Modules, Class-Modules or User-Forms
to Excel-Workbooks or Word-Documents from "outside"?
How shoud this to be done?

thx

Peter

 

[Jonathan West]

Hi Peter,

If the code is already in a complete module, then in the VBA editor you can
go FileImport to import an external module to your project. Also you can
drag a frm, cls or bas file from Windows Explorer and drop it into the
project in the procect window in the VBA editor. You can also drag and drop
modules between projects in the VBA editor if you have multiple files open.

If you want to import a single routine or a code fragment, then you can copy
& paste from the outside.

 

[Stephen Bullen]

Hi Peter,

is there a way to add Modules, Class-Modules or User-Forms
to Excel-Workbooks or Word-Documents from "outside"?
How shoud this to be done?

Yes, using the VBA Extensibility library. Chip Pearson has some
information on his web site at www.cpearson.com, and I wrote a chapter
about it in the "Excel 2002 VBA Programmer's reference".

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

 

[Peter Plumber]

Hi Peter,




Yes, using the VBA Extensibility library. Chip Pearson has some
information on his web site at www.cpearson.com, and I wrote a chapter
about it in the "Excel 2002 VBA Programmer's reference".

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

thanks a lot

Peter