View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Helmut Weber[_2_] Helmut Weber[_2_] is offline
external usenet poster
 
Posts: 163
Default Trying to use Excel to "program" word doc

Hi Eric,

Does this make sense? or should I put code in the Word doc, that pulls
the data from Excel???


that's just about the same.

The only thing you have to think about
is where the data from Excel should be placed in Word.
Working with lines is not a good concept,
as lines are recalculated on the fly
and depend on the selected printer,
on fonts available, on font substitution etc...

You may place the data at the n-th character of a doc,
before it, after it, or replace it,
at the start on the n-th section,
at the start on the n-th paragraph,
n characters after the start of paragraph x,
uncountable ways.


--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"