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

vba powerpoint
rryanp picture rryanp · Jun 28, 2012 · Viewed 10.8k times · Source

I am using VBA to paste charts/graphs from Access to PowerPoint. Once pasted, I am resizing them using VBA, but it does not allow me to use inches (even though when I do it manually through the shape Properties, the size values there are in inches).

My question is what unit of measure is the number I use in VBA? I assumed pixels and tried to convert using a 96 pixel per inch factor, but that wasn't just right. Now I'm curious about whether it's based on my screen resolution? I can quickly code it (through trial and error) to look good on my machine, but I worry then if somebody else runs it, and they have a different resolution, the slide will look different. (Note that the graphs are having to fit within other shapes.)

If it's not based on screen resolution, does anybody know the dimensions of a slide in whatever unit it's in?

Answer

Tim Williams picture Tim Williams · Jun 28, 2012

Units in ppt VBA are Points (a point is about 1/72 of an inch)

Related questions

VBA error 1004 - select method of range class failed

First time poster, so if there is any formatting, or guidelines I failed to adhere to, please let me know so that I can fix it. So I am basically asking the user for the file directory of the excel …

Read More
How to name an object within a PowerPoint slide?

So I know how to name a textbox, or a like object in PowerPoint with VB, but I was wondering if there was a way to name objects through the Ribbon (PowerPoint 2007). For instance, if I add a text box …

Read More
How to update excel embedded charts in powerpoint?

I have 30 charts that were created from excel and were pasted onto powerpoint slides. Every month, I have to update these 30 embedded charts by manually clicking on the charts and edit. I am aware there is an option to use …

Read More