Results 1 to 8 of 8
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing Alignment Problem (Office 2000)

    This is my first post in this corner of the lounge, so I hope I'm not retreading old ground. I decided to use a set of PP slides as the basis for filling out a multipage A4 pre-printed form. I used images of the printed pages, scanned directly into PP and drew textboxes in the appropriate positions. Then I deleted the images and printed my text etc. directly onto the preprinted form.

    It worked well for the most part, but the text (boxes) consistently needed to be dropped down by about 1 line height of 10pt Tahoma font, and shifted right by about 1 character width of the same font. I'm wondering if there's something I can do to ensure "perfect" alignment in the future, since this looks to be a useful general method of doing this kind of thing.

    Alan

  2. #2
    3 Star Lounger
    Join Date
    Dec 2002
    Location
    USA
    Posts
    397
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Alignment Problem (Office 2000)

    I suspect the problem is that when PPT prints, it automatically adds some margin to the page since printers can't print clear to the edge of a page. You might try unchecking the "scale to fit page" option when you go to File/Print. That might help, but I'm not sure it will.

    You might also check http://www.rdpslides.com/pptfaq/FAQ00097.htm for some other possible workarounds.

    Finally, you might consider using Adobe Acrobat for this. You could scan in your form and add form fields in Acrobat which can be reached via tab and filled in just by typing. That way you wouldn't have the kind of printing problems you're seeing with PPT.

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Alignment Problem (Office 2000)

    Thanks Echo. I had all of the scaling/ fitting options unchecked, so that wasn't the problem. The hints on the link you provided more or less confirmed my suspicions that it was a printer (physical) margin limitation, and that trial & error might be the only way to go. The kludgy fix I used was to Select All text boxes on each slide, then tweak their positions collectively by eye, using Alt to override the snap-to-grid behaviour.

    It just dawned on me (I mean right now <img src=/S/grin.gif border=0 alt=grin width=15 height=15>) that it might be easy to achieve such tweaking through VBA. I'd guess there's a collection of all the textboxes, through which they can all be repositioned identically. I'll have a go at it (never used PP VBA) then maybe throw my woes at the VBA lounge.

    cheers

    Alan

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Alignment Problem (Office 2000)

    I followed my own advice here <img src=/S/grin.gif border=0 alt=grin width=15 height=15> and came up with a macro to appropriately adjust the positions of all text boxes in the active presentation:

    Public Sub CanonPrint()
    For Each sld In ActivePresentation.Slides
    For Each sh In sld.Shapes
    If sh.HasTextFrame Then
    sh.IncrementLeft 6#
    sh.IncrementTop 12#
    End If
    Next sh
    Next sld
    End Sub

    It seems to work OK for the tests I have run, but I have a couple of queries here.

    What is the significance of the # on the points measurements?
    These appeared in a recorded macro I used, but I've not seen them before in VBA code.

    I used the HasTextFrame property to try to identify only shapes that are textboxes. Is this the right way to go generally?

    Alan

  5. #5
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Printing Alignment Problem (Office 2000)

    The # indicates that the data type is Double. If you look in the VBA help for Double you will see the text "The type-declaration character for Double is the number sign (#).". Other characters that you might see are % for Integer, $ for String, @ for currency, & for Long and ! for Single.

    6# is a double precision floating point constant with a value of 6
    6% would be an integer constant with a value of 6
    6& would be a long integer constant with a value of 6

    If is generally considered better programming practice to DIM variables before you use them and to use a prefix to indicate the data type, as in
    <font face="Georgia">DIM dblPointSize as Double</font face=georgia>
    or even
    <font face="Georgia">Const dblRightShift As Double = 6#</font face=georgia>

    StuartR

  6. #6
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Alignment Problem (Office 2000)

    Thanks Stuart. Now that you mention the $ and & suffixes, which I have used, it becomes obvious! <img src=/S/stupidme.gif border=0 alt=stupidme width=30 height=30> I was also thinking that a point measurement ought to be a whole number (like a pixel measurement) but this is also obviously not the case.

    And you're right of course - I usually work on whole projects and use "Option Explicit" with the appropriate const and dim type declarations; although I'm not so particular with variable name prefixes indicating type. You're obviously more correct here than I am. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    cheers

    Alan

  7. #7
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Printing Alignment Problem (Office 2000)

    I forgot to answer your other question.

    HasTextFrame is exactly the property to identify shapes that include text. Whether they are text boxes or any other shape.This property is also used in other Office applications for the same purpose.

    StuartR

  8. #8
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing Alignment Problem (Office 2000)

    Thanks Stuart. Slowly chewing my nails through the ins & outs of Powerpoint.

    Alan

Posting Permissions

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