Discussion Locked

Flaming June's Techno Babble

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
blog root

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.