View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NateBuckley NateBuckley is offline
external usenet poster
 
Posts: 146
Default Update a word form from Excel - tips?

Hello everyone, firstly I have a Word document for employee details, I get
the employee details from a database using Excel as a front end and wish to
put various fields into the word document.

Not done much on Excel to Word so I was wondering if anyone could throw some
tips my way, especially if those tips were to do with placing information on
certain lines?

EG I have at the moment on the form

Name: ___________

now the underscores are simply that, underscores is there something I can
add after "Name:" to make insertion easier? Perhaps some type of placeholder
that I can simply then go (in some form)
wordDocument.PlaceHolders(2).value = rs.getField("fldName").value
(that rs.etc might be wrong as just writing this up without looking).

Cheers!