I have made a mscro in Excel that can copy cells and paste them into the header of a Word document.
After paste then the Word document is viewed in normal mode. I want it to be viewed in Print Layout View.
I know that it's Word that don't do as I want it to do. But since the macro is in Excel and Word is "controlled" by Excel then i do believe that I have to ask here.
I have attached the Excel file with the macro and the Word document in the same .zip file.