I need help with a macro to nest my personal maros in. I have a workbook1 with n rows, and a folder with n files. I'd like the macro to:
(workbook1 is open)

1. open file i in E:\DIRECTORY\
2. Activate workbook1, and copy row i of workbook 1
3. paste row i into A15 of worksheet("text") in file i.
4. Search file i for worksheet names containing the following non-case sensitive strings:
- "(xyz"
If found, activate that sheet and perform personal macro1, else move on to next string
- "(old"
If found, activate that sheet and perform personal macro2, else move on to next string
- "(new"
If found, activate that sheet and perform personal macro3, else done
5. save and close file i.
6. Repeat for i+1 ...until row n/file n.

M