Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word positioning from Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word positioning from Excel
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 -----Original Message----- 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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word positioning from Excel
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 -----Original Message----- 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 -----Original Message----- 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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Positioning Excel comments for when they are displayed via mouse-o | Excel Discussion (Misc queries) | |||
excel positioning in Points for vba shapes | Excel Worksheet Functions | |||
Positioning all pictures | Excel Discussion (Misc queries) | |||
Precise positioning of a graphic in Excel | Excel Discussion (Misc queries) | |||
excel chart size using inside positioning | Charts and Charting in Excel |