VBA Copy macro-enabled worksheets to all workbooks in folder

Hello,
Perhaps I'm going about this is a convoluted way:
- I want to be able to insert specifically named macro-enabled worksheets into all excel files in a particular folder. For now, lets call them sheet1 and sheet2. (The excel files that are receiving new sheets may or may not be macro-enabled)
- I, then need to run a macro within those newly updated excel files.
- I found VBA to insert an active sheet across all worksheets in a folder, but I want to be able to reference sheets the will be inserted.
- Can this code be edited to do that?

Please Login or Register  to view this content.

Thanks,
Karim