Thread: Excel to Word
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.word.vba
EA EA is offline
external usenet poster
 
Posts: 28
Default Excel to Word

I am trying to write a procedure which, from Excel, creates a Word document
and then adds text at various bookmarked locations.

I have got the code which creates the document but I am having trouble
inserting a range of cells from Excel.

The first two lines below work fine, but the last errors

.Bookmarks("Client").Range = Range("A7")
.Bookmarks("ClientContact").Range = Range("B7")

.Bookmarks("DealTable").Range = Range("DealRange")

Does anyone have any code or any references which will point me in the
direction of an answer to how I insert a names range of cells into a Word
document.