Link to home
Start Free TrialLog in
Avatar of ouestque
ouestqueFlag for United States of America

asked on

Excel 2007 Vba: find original size image

Whst Vba do I need to find the original size height of an image

I.e.
When I right click an image and go to "size and properties" I see "height" under the "original size" section. (that is the number I am trying to retrieve.
SOLUTION
Avatar of Arno Koster
Arno Koster
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The resulting numbers are dimensions in points.
To get the dimensions in inch, divide by 72.
Avatar of ouestque

ASKER

Thanks akister, but if the shape is cropped the "original size" will be different than .height.

Example: if I crop an image from top 100 inches and if the image is 105 inches then...

".height" will = 5 inches. "original height" will be 105. (which is the value I'm looking for)
Same with ".width". I am looking for the "original size" not current size after cropping and scaling.
ASKER CERTIFIED SOLUTION
Avatar of ScriptAddict
ScriptAddict
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks all!!!