Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning Excel comments for when they are displayed via mouse-o matthewtec Excel Discussion (Misc queries) 2 January 9th 09 11:19 PM
excel positioning in Points for vba shapes Kelzina Excel Worksheet Functions 1 November 15th 06 02:22 PM
Positioning all pictures gejmond Excel Discussion (Misc queries) 3 June 26th 06 08:48 PM
Precise positioning of a graphic in Excel fishbin Excel Discussion (Misc queries) 4 December 22nd 05 04:13 AM
excel chart size using inside positioning Travis Charts and Charting in Excel 2 February 15th 05 04:10 AM


All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"