Geek Answers Handbook

What is the unit of measure for PowerPoint slides using VBA?

I am using VBA to insert charts / graphs from Access into PowerPoint. After insertion, I resize them using VBA, but it does not allow me to use inches (although when I do this manually through the Properties form, the size values ​​are in inches).

My question is, what unit is the number I use in VBA? I assumed pixels and tried to convert using a ratio of 96 pixels per inch, but that was not the case. Now I wonder if this is based on my screen resolution? I can quickly copy it (via trial version and error) to look good on my machine, but I'm worried if someone else runs it and they have a different resolution, the slide will look different. (Note that graphs must conform to other forms.)

If it is not based on screen resolution, does anyone know the dimensions of the slide in any part of it?

+7
source share
3 answers

Units in ppt VBA are dots (dot is about 1/72 of an inch)

+15
source

Forgive pedantry, but an inch is exactly 72 points, at least until PowerPoint and almost any digital system.

Before computers took over, the "o" really applied. Moreover, there were several different "standard" definitions of this point.

http://en.wikipedia.org/wiki/Point_ (typography)

AAMOF, in one ... er ... point, Microsoft redefined cm (2.4 per inch instead of 2.54) according to its own goals, which led to confusion when people in the metric change precisely defined measurements in PowerPoint, then figured out that things did not print at the expected size.

They fixed it in PPT 2002, but I would still have files floating around it, when they open in current versions of the application, they show odd page sizes.

+4
source

On Windows, it is 96 ppi .

On a Mac, it's 72 pixels per inch .

+1
source

More articles:


All Articles