Automatically Copy Macro to new Workbook

[ebrandt]

I have written a macro which moves selected worksheets to a new workbook and renames it.

I need the new workbook to include another macro I have written that sorts data in the worksheets.

How do I copy an existing macro to a new workbook within the macro that creates the new workbook?

 

[Darren Bartrup]

Hi & welcome to the board.

Wouldn't it be easier to create a template blank workbook which already contains the code.

Then just open the template move the required sheets to it and save it under a new name.

Much simpler than trying to write code into the VBE at run-time in my opinion.

 

[ebrandt]

That makes a lot of sense. I should have thought of that. I will give it a try.

Thanks.

 

[AlphaFrog]

Alternatively, you could copy the whole workbook (instead of just certain sheets), then delete the sheets in the copied workbook you don't want to keep.