How to create a workbook with presaved macros

[masterxl]

Hi All,

I am creating a VBA application, I'm faced with a problem that is-- When a ever i create a new workbook, i am unable to get macros with which it has been created..

Plz provide me the solution...

Thanks In Advance

 

[RoryA]

I'm afraid your question makes no sense at all to me. Can you please clarify what it is you want?

 

[masterxl]

I'm afraid your question makes no sense at all to me. Can you please clarify what it is you want?

Sorry For Inconvenience,

let us assume I have macro 'A', After Running 'A', it will create workbook 'B'.

What all i need is---- The Workbook 'B' should have macro 'A'.

 

[RoryA]

The easiest way is to create a template that contains the macro(s) you want and then use that when you create the new workbook. Or simply save the original workbook under a new name - it will contain all the same code.

 

[Ruddles]

I agree with Rory - that seems like the easiest and neatest solution.

However if you actually want to copy a module out of your workbook into another workbook, check this link.

 

[masterxl]

Thanks to you Both !!