Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    269
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Vertical text (Word 97)

    I need to print some text on sheets of A4 labels 2 x 4 to an A4 page. As the labels are landscape, I need to be able to print the text vertically (as if the labels were portrait). I will need to construct a dialog box to collect the information to be printed, together with the number of labels to print (of same information) and the number of labels to skip on the sheet prior to printing the first label (if any).

    I would be grateful for some advice on how to do this.
    <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22>

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts

    Re: Vertical text (Word 97)

    With regard to needing to print the text vertically onto the landscape labels, do you not instead have the option to change the page orientation of the Word document to landscape? (Unless I'm visualizing this incorrectly, that would allow you to enter the text in the labels in a more normal horizontal fashion.)

    Constructing a dialog box to collect the information would be pretty simple but does require working with VBA and the VB Editor - have you done any projects with these before?

    Most likely this would best be deployed as a template, with code that's set up to display the dialog box when a new document based on the template is created.

    Gary

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    269
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Re: Vertical text (Word 97)

    Hi Gary

    Thanks for the response. It is of course very logical to set the page up as landscape, then print on the sheet normally, instead of trying to print vertically - which is what I tried first ... except that Word 97 has some very strange ideas about page rotation. Instead of showing the 8 landscape labels on the single page rotated 90 degrees and therefore in portrait mode, it shows 4 labels on each of two pages and the labels are still in landscape mode!

    Regarding VB, the only thing I would have trouble with is the part of the code that prints and/or skips the number of labels entered.

    Regards
    <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22>

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

    Re: Vertical text (Word 97)

    Hi useful,

    I think you have to set up a new label type, and do all the settings there, including page layout. See the attached document.

    HTH,
    Hans
    Attached Files Attached Files

  5. #5
    3 Star Lounger
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    269
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Re: Vertical text (Word 97)

    Hi Hans

    Very clever ... I didn't realise that there would be an A4 Landscape option under Paper Size! Thank you very much for the advice!!

    All that I would now love some help with is the code required for skipping the number of labels entered and printing the required number of labels.

    Thank you.

    Regards
    <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22>

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

    Re: Vertical text (Word 97)

    Here is a new attachment. It is a (zipped) template, not a document. To use it, you must unzip it and copy it to your template folder.

    You can create a new document based on the template by selecting File/New...
    Select the template and click OK.
    You'll see a dialog box in which you can enter:

    (1) The text for the label (use the Enter key if you want multiple lines).
    (2) The number of labels to skip (must be in the range 0...7).
    (3) The number of identical labels to fill (must be > 0).

    Click OK to create the labels.
    Click Cancel to ditch the new document.

    If you open the template directly, you won't see any tables. Because you may want to create more than one page of labels, it is not practicable to have the table in the body of the template. Instead, there is an AutoText entry named "Table" that is inserted into the document for each new page.
    The code behind the dialog box depends heavily on the form of the table; I have inserted comments that may be helpful if you want to adapt it.

    Regards,
    Hans
    Attached Files Attached Files

  7. #7
    3 Star Lounger
    Join Date
    May 2002
    Location
    Melbourne, Australia
    Posts
    269
    Thanks
    32
    Thanked 0 Times in 0 Posts

    Re: Vertical text (Word 97)

    Hi Hans

    I don't know how to thank you for taking the time and trouble to help me. You're really great!!

    Thank you!

    Regards
    <img src=/S/aussie.gif border=0 alt=aussie width=21 height=22>

Posting Permissions

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