passing a macro from one workbook to a another workbook

[mort1703]

Hi

I am expecting a NO to this question but if its possible I am all ears.

I have excel project I have been working on.

Within the project I create NEW workbooks based on set criteria and this seems to work without problems.

ie
1. Macro A - creates a NEW workbook based on criteria - working already
2. within Macro A - can I pass a module or a different macro to the workbook created within step 1.
3. if step 2 is possible, is it possible to code the transfer within Macro A.

Any help or advice on this one would be appreciated

Thanks

 

[Norie]

Why not create a template with the code you want in the new workbooks and then use that when creating those new workbooks?

 

[mort1703]

At the moment I am doing the following
1. run Macro A - this creates the NEW workbook
2. I then add the code manually.

just a thought

could I automate importing a module?

 

[Norie]

Why don't you create a template workbook with the code and use that when creating the new workbook?

You can use code to import a module to a workbook but it has various implications, for example you would need to lower the security settings to allow programmatic access to VBE.