Hi, I have been Googling for quite a while now, and doing that, I have seen that most macros where written and used by Excel. I want to do a macro in word that will open a specific sheet in the excel workbook and copy its contents to a ready-made word template . Can anyone help me in achieving this? With my current code, I can just do until the opening of a certain sheet. But I cannot seem to find any code (word macro code) that can copy the contents and paste it in a ready made word template. Thanks guys.