Paste Variables from Excel into Word template

J

Jimbob

Hi
I have an Excel spreadsheet and a macro collects various items (strings and
integers) which I'd like to paste into an existing Word template at known
bookmarks.
Having collected the variables, my macro can open the Word template from
Excel and Go To a Bookmark but how can I paste a variable at each?

I hope you can help. Thanks in anticipation
 
D

Doug Robbins - Word MVP

Use

ActiveDocument.Bookmarks("Bookmarkname").Range.InsertBefore [yourvariable]

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
 
Top