Save print option 'FitToPage' (Fit to scale paper) using VBA?

  • Thread starter Thread starter Vincent Verheul
  • Start date Start date
V

Vincent Verheul

Hello Group,

I am using Visual Basic for Applications (VBA) to create a Powerpoint
presentation. I use a custom paper size depending on the size of the
'drawing'. To print successfully, I want to use the 'Fit to scale paper'
option.

I want to automate this: I set the .PrintOptions.FitToPage to MsoTrue for
the presentation and save it. I want to print later.

However, when I open the presentation, the print option 'Fit to scale paper'
is still off. What am I doing wrong here?

Thanks!
Vincent
 
Vincent Verheul said:
Hello Group,

I am using Visual Basic for Applications (VBA) to create a Powerpoint
presentation. I use a custom paper size depending on the size of the
'drawing'. To print successfully, I want to use the 'Fit to scale paper'
option.

I want to automate this: I set the .PrintOptions.FitToPage to MsoTrue for
the presentation and save it. I want to print later.

However, when I open the presentation, the print option 'Fit to scale paper'
is still off. What am I doing wrong here?
Click to expand...

Help says this about the PrintOptions property:

Returns a PrintOptions object that represents print options that are saved with
the specified presentation. Read-only.

The various properties of the print options object are read/write but if
something's stored with the presentation, it's very well hidden. I think Help
is wrong on this one.

It's possible to set some print options manually so that they ARE saved with
the presentation (see Tools, Options, the Print tab) but these options aren't
exposed to VBA, so you can't set them programmatically.

You may have to resort to SendKeys to get at 'em.
 
Hello Steve,

Thanks! It's a pity this can't be done through VBA, I will try the SendKeys
work-around.

Kind Regards,
Vincent
 
Back
Top