Hi All

In a folder there are 5 workbooks named A,B,C,D,E . I want the code that
1. opens all the spreadsheets in a folder ,
2. automatically enable macros in them
3. Then copy sheet1 in workbook A and email it to a list of recipients.

I hope anyone can figure it out for me.

Thanks a lot.