How to write to module (like macro recorder)

[McGinley57]

Is there a way to copy code from one module to another using VBA code?

For example, in Excel I'd like to create a new worksheet, then copy some custom functions to the worksheet object from a specific module within the VBA project.

Thanks in advance.

 

[MajP]

Google vba extensibility

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=307

 

[McGinley57]

Thanks. This is just what I needed.