Word positioning from Excel

[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

 

[Joe Bloggs]

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

 

[Taras]

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