General discussion

Locked

Flaming June's Techno Babble

By ladyblitz ·
Tags: Off Topic
blog root

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

VBA Issues

by ladyblitz In reply to Flaming June's Techno Bab ...

<p>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!!</p>
<p>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.  </p>
<p>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 . Any help would be much appreciated! Thanks!
<p>Here's the code for this section of the process:
<p>Sub WordHeader()
<p>Dim Word As Word.Application
<p>Dim Heading As Range Sheets("Airframe").Activate
<p>Set Heading = Worksheets("Airframe").Range("A1:E2")
<p>ThisWorkbook.Sheets("Airframe").Range("A1:E2").Copy
<p>Set Word = GetObject(, "Word.Application")
<p>Word.Selection.EndKey Unit:=wdStory
<p>Word.Selection = wdSeekCurrentPageHeader
<p>Word.Selection.Paste
<p>Word.Selection = wdSeekMainDocument
<p>End Sub </p>

Back to After Hours Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums