mrwad
New Member
Hello everyone!
The problem is that I need to get some text to header and footer. I can create Word template and insert it to Excel as an object. I can use predefined bookmarks to insert text from Excel to Word header and footer. Then I would like to use my code to insert text. How it is possible with code to firstly insert bookmarks and then exit header and footer and start to input the code? Also embedded Word template should be opened as a copy, as I do not want to make any changes to original file or null it with the code.
1) Open embedded Word document as a copy from Excel
2) Insert text from Excel to Word Bookmarks located in header and footer
3) Jump out of bookmark and start to input text to Word document
The problem is that I need to get some text to header and footer. I can create Word template and insert it to Excel as an object. I can use predefined bookmarks to insert text from Excel to Word header and footer. Then I would like to use my code to insert text. How it is possible with code to firstly insert bookmarks and then exit header and footer and start to input the code? Also embedded Word template should be opened as a copy, as I do not want to make any changes to original file or null it with the code.
1) Open embedded Word document as a copy from Excel
2) Insert text from Excel to Word Bookmarks located in header and footer
3) Jump out of bookmark and start to input text to Word document