Copy & Paste Problem

[BIGDOG1013]

Im Having 2 problems.
1) How do u open the existing document without wiping out previous changes(like the bookmarks I added). The following code seems to create a new word doc instead of using the existing document embedded.

2) How would I Paste spreadsheet range onto Page2? Bookmarks?

The following code is what I have come up with so far:

Excel.ActiveWorkbook.Worksheets(1).Shapes("OBJECT 1&quot.Select
Selection.Verb Verb:=xlPrimary
Excel.Range("Range&quot.Copy
Word.Documents(1).Select
Word.ActiveDocument.Bookmarks(1).Select
Word.Selection.PasteSpecial

Excel.ActiveWorkbook.Worksheets(1).Shapes(1).OLEFormat.Activate
instead of the first two lines of code

 

[hermanlaksko]

Q1: Use document templates.

Q2: Yes a bookmark could be your solution.

Herman

 

[TonyJollans]

Hi BIGDOG1013,

I don't really understand what you mean by open the existing document without wiping out previous changes(like the bookmarks I added). But, bookmarks can be deleted by the code you show, depending on how they are set up.

If a bookmark is created with the selection collapsed (i.e. at an insertion point) then all works as I think you want. If a bookmark is created without collapsing the selection (in other words you select some text and then insert a bookmark) then when the bookmark is selected, the text is also selected and when you paste over it, the text is deleted along with the bookmark.

Enjoy,
Tony