#1
|
|||
|
|||
Excel VBA: PixelsToPoints???
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 |
#2
|
||||
|
||||
From Word's vba Help file:
Code:
MsgBox "320x240 pixels is equivalent to " _ & PixelsToPoints(320, False) & "x" _ & PixelsToPoints(240, True) _ & " points on this display." Code:
MsgBox "180x120 points is equivalent to " _ & PointsToPixels(180, False) & "x" _ & PointsToPixels(120, True) _ & " pixels on this display." PS: Please don't post Excel vba queries in the Word vba forum - post them in the Excel forum.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
Yes. I moved it here ...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Oh... it seemed to have been done by me a few times.
|
Thread Tools | |
Display Modes | |
|
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 |