[AccessD] Help With Word Basic

MartyConnelly martyconnelly at shaw.ca
Fri May 14 15:05:10 CDT 2004


If you are looking for Word VBA examples hunt around here

 http://word.mvps.org/Tutorials/index.htm

and here is a list of sites
http://www.mvps.org/links.html#Word

Cindy Meister's is good for mail merge problems
http://homepage.swissonline.ch/cindymeister/

Andy Lacey wrote:

>I justify posing this here on the tenuous grounds that it is VBA and it's
>probably of interest to others who have Access systems that interface to
>Word.
>
>I have a mailmerge system running nicely to produce quotations. What I want
>to do now is vary one of the paragraphs according to two criteria. The
>alternative paras still need to be held in Word so that the user can easily
>alter and can format them. These paras also contain one or two merge fields.
>My solution, which I though reasonably elegant, was to set up a new doc
>specifically for these alternative paragraphs with a table containing 3
>columns and several rows. The first column is purely descriptive. The second
>and third columns hold versions of the text. So what I can do is calculate a
>column and a row index from my data and pick the appropriate cell in the
>table. So far so pretty good. But then we encounter the horrors of Word
>Basic. What I've managed to achieve is opening the doc, and pointing a
>Selection object at the cell. But how to get the contents of that cell into
>my main doc? If I use the Copy method what gets copied to the clipboard is a
>complete cell not just its contents, and pasting it back brings in a
>single-cell table complete with border and formatted accordingly. But I only
>want to copy the cell contents. I can do it manually but can't for the life
>of me see how to do it in code. The selection object has a Text property,
>but you can't Copy that, and even if you could I don't know what that would
>do with the embedded merge field. Can someone (Bryan for example?) help?
>Where am I going wrong. I always have this kind of trouble with Word Basic,
>it's a nightmare unless you've got an example to work from.
>
>--
>Andy Lacey
>http://www.minstersystems.co.uk
>
>
>
>
>________________________________________________
>Message sent using UebiMiau 2.7.2
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada






More information about the AccessD mailing list