I want to make a VBA which can help to copy data from ALL word files in a folder to a template file that has preset header and footer.
1) Folder has 12 word files (ie. File1 to File12)
2) VBA should open File1, copy select all contents and paste into template word file.
3) Afterwhich, save template word file as PDF in another folder
4) Pt 1 to 3 should repeat for all files in folder. In this case, since there are 12 word files, there should be 12 PDFs.
Appreciate if someone can help with this pls? Thanks!!