View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.beginners
Mike NG Mike NG is offline
external usenet poster
 
Posts: 87
Default passing variables from excel to word

On Sat, 19 Jul 2003 at 20:22:32, Doug Robbins - Word MVP (Doug Robbins -
Word MVP ) wrote:
In the Word VBA code, you can use oDoc.Variables('Product") or
oDoc.Variables('Product").Value (though the value is not really necessary
because it is the default property of a Variable. Having does maybe make
the code a bit easier to understand )

The variables do not have to appear anywhere in the document if you don't
want them to, so you can leave the value in them. If you do want to display
the value of the variable in the document, you do so by use of a {
DOCVARIABLE "Product" } field.

OK thanks - I will give that a go some time soon - just been away for a
long weekened
--
Mike