Excel/Word VBA

[javydreamercsw]

I've seen how to write/read Word documents from Excel via VBA bu
writing in certain formats is kind of hard. Ignoring that part th
problem comes when the document changes for some reason and since it i
hard coded your codes must change. So I had this idea, nothing new b
the way, of creating like a interpreter. Like open a WORD templat
where it has words like this in the code:
$%Dean%$

And that when the interpreter identifies that string, mayve with
switch, it fills the info necesary doing a query to a databas
(Access). As of now I can read whole lines but didn't found a way t
inspect the contents of each line to search for that type of sring. An
idea

 

[pikus]

Use Bookmarks. They're specifically for that purpose (among othe
things), they're invisible, much easier to use and much faster sinc
you don't need to search the whole document. VBA allows you access t
all the functionality of Word though the Object Model is quit
different from that of Excell, so I'd recommend reading up on that.
Piku