How to call a module for returning an excel picture to the .ActiveDocument.Bookmarks("bookmarkname")

[Bon]

Hello all

I created a module which copy an area of excel cells (e.g. A4551).
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

 

[Anne Troy]

See if this sample code helps, Bon. Likely, it's not exactly what you need,
but you might be able to steal some code from it.
http://vbaexpress.com/kb/getarticle.php?kb_id=381

************
Hope it helps!
Anne Troy
www.OfficeArticles.com