Word positioning from Excel

  • Thread starter Thread starter Taras
  • Start date Start date
T

Taras

I've created a Word document and written to it from Excel.
I can insert page breaks as required and continue writing
from there.

What I can't do is insert a table at the current end of
document. It always goes to the top.

What is the easiest way to always insert text, tables,
etc. at the current end of Word document?

TIA
 
Taras

Recording a macro in Word to go to the end of the document
gave me

Selection.EndKey Unit:=wdStory

Insert this before the copy

Peter Atherton
 
Thanks, that worked. I guess I had been banging my head
trying different things to try Word macro avenue. Just
to clarify, the code you need in excel is:

Dim wdAPP As Word.Application
Dim wdDoc As Word.Document

'appropriate opens

With wdDoc
wdAPP.Selection.EndKey Unit:=wdStory
End With
 
Back
Top