Images resizing when excel range is pasted into PPT using VBA across different Operating system

[Kanike Vamshi Krishna]

Hi,

I have automated a process of pasting Excel ranges as images into PPT through VBA. The dimensions like ".width",".height",".left" and ".top" are set after pasting the image.

I was initially working on Windows 7 and had the dimensions according to them. But when I tried to use the same macro in Windows 8, the size of pasted images is stretched too wide. I am confused around why this is happening even when I have defined the dimensions before hand.

Any help is much appreciated.

 

[pbornemeier]

Try unlocking the aspect ratio of the image before setting the size/position after pasting. For one of my programs PPT was stretching the image to max width when pasting it in VBA and this change fixed the problem.
Selection.ShapeRange.LockAspectRatio = msoFalse