Excel VBA: PixelsToPoints???

tinfanide · #1 04-15-2012, 10:12 PM

As mentioned, any VBA method to convert pixels to points?
I've tried:

Code:

''' 72 pixels should be approximately 8.38 (?unit)
ActiveWindow.PixelsToPoints(72)
''' return 0

macropod · #2 04-16-2012, 05:17 AM

From Word's vba Help file:

Code:

MsgBox "320x240 pixels is equivalent to " _
    & PixelsToPoints(320, False) & "x" _
    & PixelsToPoints(240, True) _
    & " points on this display."

Also from Word's vba Help file:

Code:

MsgBox "180x120 points is equivalent to " _
    & PointsToPixels(180, False) & "x" _
    & PointsToPixels(120, True) _
    & " pixels on this display."

Excel doesn't have the same methods, so you can't do this from Excel unless you use the Windows API or an application whose object model does support them.

PS: Please don't post Excel vba queries in the Word vba forum - post them in the Excel forum.

tinfanide · #3 04-18-2012, 07:14 AM

Quote:

Originally Posted by macropod

From Word's vba Help file:

Code:

MsgBox "320x240 pixels is equivalent to " _
    & PixelsToPoints(320, False) & "x" _
    & PixelsToPoints(240, True) _
    & " points on this display."

Also from Word's vba Help file:

Code:

MsgBox "180x120 points is equivalent to " _
    & PointsToPixels(180, False) & "x" _
    & PointsToPixels(120, True) _
    & " pixels on this display."

Excel doesn't have the same methods, so you can't do this from Excel unless you use the Windows API or an application whose object model does support them.

PS: Please don't post Excel vba queries in the Word vba forum - post them in the Excel forum.

Did I happen to post this thread in the Word vba forum?

macropod · #4 04-19-2012, 04:40 AM

Quote:

Originally Posted by tinfanide

Did I happen to post this thread in the Word vba forum?

Yes. I moved it here ...

tinfanide · #5 04-19-2012, 07:58 AM

Quote:

Originally Posted by macropod

Yes. I moved it here ...

Oh... it seemed to have been done by me a few times.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 custom ribbon not showing in Excel 2010	Paulzak	Excel	2	02-17-2012 06:35 PM
saving data in excel 2010 from excel 2003	johnkcalg	Excel	1	02-06-2012 07:33 PM
VBA code from Excel 2007 in Excel 2010	csam63	Excel Programming	1	10-07-2011 10:46 AM
Excel Hyperlinks crash Excel programme	martinlest	Excel	8	01-26-2011 04:23 AM
Opening multiple Excel files within the same Excel window.	lost9471	Excel	2	05-01-2010 01:57 PM