How to Get a Macro to save a New File but include some of the Macros from the original File?

[John_B]

Hello,

I am currently writting a macro which requires that the data after the macro is ran, to be put into a new workbook.

However, I need some Macro code to go over with it for use later on the data present.

Is it possible to have the macro copy another macro to another workbook?

Thanks in advance

 

[mohan.pandey87]

you can take help from these sites:

Programming In The VBA Editor
OR
http://www.rondebruin.nl/win/s9/win002.htm

 

[John_B]

Also it needs not to remove the Macros from the current file as it is meant to be a master file

 

[mohan.pandey87]

Take help from the sites which i have provided in 2# post