Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    AddressLayout Syntax (any)

    I posted in the Word forum <!post=here,198153 >here<!/post> but got no response.

    Did I strike out because I used the word "code" ??

    If so, then this is the right place. Could my fellow coders check this
    out and see if you can decifer for me.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: AddressLayout Syntax (any)

    Kevin:
    The braces and vertical bar indicate a mandatory choice VBA must make between the items listed inside the braces. In your case you have given VBA two choices to review, the items left of the vertical bar and the items right of the vertical bar.
    So in your code there are three items left of the vertical bar PR_Company Name PR_Street Address PR_Locality on the right side you have only two PR_Street Address PR_Locality .
    As you can see the only difference between the choices is the company name element.
    In other words a left choice by VBA produces 3 lines a right choice produces 2 line.
    To you it seems like an if / then type statement is being performed when VBA is using the Option Statement Syntax to get the job done.


    As for the other items in your code (outside) the braces they are mandatory and will always generate data from the address book both before and after the code in braces.

    Hope this helps.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AddressLayout Syntax (any)

    This is interesting. Where did you learn this?

    And what is "Option Statement Syntax"?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: AddressLayout Syntax (any)

    Ya'll see the <!post=Word Post,199606>Word Post<!/post> in the thread of the same name for the solution!

    Man, if feels good to have bagged this one...
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •