1 reply
by ladyblitz
Today has been interesting. Work is looking up for now. I'm so frustrated though. I've spent probably an hour or more looking for the answer for this issue!!
I figured out how to move the Excel information on the proposal template I'm doing into Word. Everything is finished. Except the Headers and Footers in Word. I can't figure out how to format them in Word from Excel.
Does anyone know if this Is even possible with the differences between the Excel and Word headers? The code I've written runs and pastes the data . . . at the end of the document :P. Any help would be much appreciated! Thanks!
Here's the code for this section of the process:
Sub WordHeader()
Dim Word As Word.Application
Dim Heading As Range Sheets("Airframe").Activate
Set Heading = Worksheets("Airframe").Range("A1:E2")
ThisWorkbook.Sheets("Airframe").Range("A1:E2").Copy
Set Word = GetObject(, "Word.Application")
Word.Selection.EndKey Unit:=wdStory
Word.Selection = wdSeekCurrentPageHeader
Word.Selection.Paste
Word.Selection = wdSeekMainDocument
End Sub
This discussion is closed to new replies.
Trending After Hours posts
Sort by Trending