Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Range Selection (XP)

    How can I with VBA select the first column ( or any specific column) within a multiple Text Columned document. I want to select the whole of one column on a certain page. In fact, I want to be able to iterate through all the pages, and set each column's range to a variable.
    Thanks,

    pmatz

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Range Selection (XP)

    Is it not possible to use a multiple columned table in stead of text columns. It would be easier to select the first column from a table than from a text column. Text columns operate on paragraphs, not "columns" as such. It is going to be difficult to write vba code to select the first column in a column of text?!
    Regards,
    Rudi

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range Selection (XP)

    Thanks Rudi, I thought that this may be the case, and couldn't think of a way of flagging whether the paragraph was in the 1st or 2nd column on a page!.

    The tables option may work, but if I expand on what I am trying to do ...

    I have done a mail merge from an AccessDB, and it is a directory type of document. I had used 2 text columns to enable a 'booklet' type of directory, and all this has gone well. I have got the formatting really together on it, even a front page befor ethe 1st record...but i digress.

    My friend pointed out that the 'booklet' type pages using these text columns will be out of sync alphabetically, as you may imagine, so I was thinking of making each column on the merged document a range, and then swapping them over to the correct relevant page so that when printed they would all be in the correct order. It was a first(and probably crazy) step. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>

    I know Word does 'booklet' printing, and am aware of 'duplex' printing - though never used or delved into this. Perhaps I will just print out the directory on 1 page and then use a photocopier to get each page sorted manually.

    I may try using a single cell table each side of the text columns though - this might work!
    Thanks,

    pmatz

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Range Selection (XP)

    I can't give much more advice on this. I get a better picture of what your needs are based on your latest post. The easiest way (according to my knowledge) is to use a table. Maybe there is a way that you can mark off the beginning and ending of each paragraph, using bookmarks or styles. Then get vba to select the text of that paragraph based on the bookmark position etc. I'm thinking out loud and probably out of my league here; but ideas are usually the beginnings of a solution.

    Don't give up...maybe someone else has a solution that neither of us has thought of. I'll keep an eye on this post, and see what develops!!!!
    Regards,
    Rudi

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Range Selection (XP)

    I agree with Rudi that text columns are not easy to manipulate in code. The 'Book fold' option in File | Page Setup... is probably the way to go instead of text columns. Word will take care of the order of the 'pages'.

  6. #6
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range Selection (XP)

    <img src=/S/grin.gif border=0 alt=grin width=15 height=15> <img src=/S/grin.gif border=0 alt=grin width=15 height=15> <img src=/S/grin.gif border=0 alt=grin width=15 height=15> SORTED!

    I just got my head around said book-fold option in the page setup, and now understand how it works. I don't need to merge to columns or anything like that, I just merged to normal page and then copied into a new document which I set up as booklet. When I printed this off it had indeed paginated the document properly for me.

    Simple really, but I was very confused by Word's help - unusual i know <img src=/S/tongue.gif border=0 alt=tongue width=15 height=15>.

    I hope i can merge directly to a page set up as booklet, should be able to. [img]/forums/images/smilies/biggrin.gif[/img]
    Thanks,

    pmatz

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Range Selection (XP)

    > I hope i can merge directly to a page set up as booklet

    That shouldn't be a problem - the merge process doesn't know, and doesn't need to know that the document is set up as a booklet.

  8. #8
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Range Selection (XP)

    Cool, thats good news, will try it in a bit, im kinda doing 3-4 things at once over the last few daze.

    got the duplex thinger sorted too <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Fridayfridayfriday!!
    Attached Images Attached Images
    Thanks,

    pmatz

Posting Permissions

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