Unasked Question is the Dumb Question

Discussion in 'Visual Basic ( VB )' started by Lennie, Feb 5, 2008.

  1. Lennie

    Lennie New Member

    Joined:
    Feb 5, 2008
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    Analyst Progammer
    Location:
    New Zealand
    It’s too long since I did this sort of thing. And the program is
    no longer available. Can I make VB do this for me, within MS
    Word for Windows. (Office 2000 on w2kp)

    Roughly speaking, I’m seeking to extract data from a data source,
    more or less like the following:

    Bracketed words signify <field name>

    IF <keyword> contains (the word) 'redundant' [true response]
    skip to next record (and repeat that test [for every record!])

    Should that above conditional test return a [false response]
    then, extract the data from the record, thus:

    Insert <name1> data in bold, followed by a tab, then move
    to the next field.

    IF <name2> contains data, insert that data, followed by a
    comma and a space, ELSE IF <name2> contains no data,
    skip to next field.

    . . . . . . . . .

    If <home_tel> contains data, insert the text string "Home
    Tel:" in bold, then the field data, followed by a comma and a
    space, ELSE IF <home_tel> contains no data, skip to next
    field.

    On and on and on . . . . till the end-of-record, [where two
    carriage returns are inserted] then move to the next record
    until end of file. (Ye olde WHILE WEND instruction?)

    The desired outcome of this exercise is a WP file printed on
    A5, (or two columns on A4 landscape) for inclusion in a
    small diary/ring-binder.

    The data source has 26-30 fields per record and less than
    1k records.

    Perry <sighs>
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice