Controlling MS Word from VBA Excel
 

hello. i am looking for some help with dropping excel generated objects

(specifically a range object and a chart) into a specific place within
a word document. specifically, within the document, i have two "place
holders": one portion of text that reads <DROP CELLS HERE and one
portion of text that reads <DROP CHART HERE. Once I have generated the

range object and chart, i would like to open the word document, find
the instances of <DROP CELLS HERE and <DROP CHART HERE, and paste the

objects where the place holders are. can someone provide some tips
please? it would be much appreciated. thank you.

Controlling MS Word from VBA Excel
 

In WORD you should add some bookmarks to the document where you want
the charts or cells. From there excel you can easily point to those and
insert your objects in the

Word.Selection.Bookmarks("Bookmark1").Range.Text = MyObject

Good luck
Peter

Controlling MS Word from VBA Excel
 

Thanks Peter, I really appreciate it! I will try it out...