Get PNG height and width

Hi expert,

For other image format, i can use below to get the Height and Width

Set p = LoadPicture(imagefile)
PicHt = p.Height
PicWid = p.Width

But loadpicture not support PNG file format, is that any other method to do so?

Hi Lewis,

Thanks for help, actually I tried to use Picture.Insert before, but seems this is only insert the link to excel but not the actual image....

After inserting, I changed the name of the .png file, closed Excel, and opened the file again. The image seems to be a permanent part of my Excel file using Excel 2003.

When I remove the image from the Excel file, the Excel file size decreases by the size of the .png file.

Lewis