• Vertical text (Word 97)

    Author
    Topic
    #374364

    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.
    aussie

    Viewing 0 reply threads
    Author
    Replies
    • #605371

      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

      • #605397

        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
        aussie

        • #605407

          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

          • #605413

            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
            aussie

            • #605420

              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

            • #605598

              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
              aussie

    Viewing 0 reply threads
    Reply To: Vertical text (Word 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: