How to paste a copied range of cells in Excel under Word bookmark

B

Bon

Hello all


I created a module which copy an area of excel cells (e.g. A45:D51) in
MS Word 2000.
How can I call this module and use
..ActiveDocument.Bookmarks("bookmarkname") to paste the copied area of
cells into the Active Word document under the bookmark?


If a module is returned a text string, I can use
..ActiveDocument.Bookmarks("bookmarkname").Range.Text =
ModuleThatReturnText


How about the module which has already copied a range in Excel
worksheet and want to paste it under the bookmark?


Cheers
Bon
 
W

Word Heretic

G'day "Bon" <[email protected]>,

..ActiveDocument.Bookmarks("bookmarkname").Range.Paste

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Bon reckoned:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting a cell into bookmarked table from excel vba 1
How to call a module for returning an excel picture to the .ActiveDocument.Bookmarks("bookmarkname") 1
Paste to excel from word - auto format problem 1
How to copy pictures in Excel and paste them under a word bookmark 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
tables.cell string used as bookmark name 3
How to copy cells excel data and paste them under MS Word bookmark 0

Top