Determine Page Setup of Each Report in VBA

[Guest]

I have a application where I wish to embed some of my access reports in power
point. The only way I found was to print my access to Acrobat and convert it
to .jpg. I have VBA code that insert the .jpg images into power point slides
automatically. I need to define the slide height and width and the image
too. If I don't, the image takes on a much larger size and slide show
doesn't fit.

I have a macro in Access openning and print my reports. How can I determine
the report orientation (portrait or landscape) and page setup information
like size of the paper in VBA???? If I can get that information, I can do
complete the process.

Thanks,

Gary

 

[Allen Browne]

See help on PrtMip.

It's messy, but it works.