Worked out why it goes wrong. When making a recorded macro it put it in as a sub macro. I just needed to move the recording part into the top function and it worked.


Now though although I can insert into a doc already open the batch part is now the problem and it doesn't do anything to those files. I had used the insert cover sheet as a test.


Actually I have just realised it has inserted the cover sheet into the same file multiple times haha. At least I am moving forward