Crop Image via VBA in PowerPoint

[G.Bregvadze]

Hi,

I am using the code:

Please Login or Register  to view this content.

to crop the image on the slide, however it gives the possibility to crop by fixed size (10).

Is it possible to identify via VBA by how much the picture is outside the slide area and crop the image by that size?

[Andy Pope]

change slide index and shape name to suit.

Please Login or Register  to view this content.

[G.Bregvadze]

Thanks for the great code, but can it be modified to include it in Excel VBA so it can be ran from Excel ?

As I understand we need to add PowerPoint.Application.

[Andy Pope]

Sure.

I assume from the example code you posted that you already have an object referencing powerpoint, so you can just use that in the code.
I have assumed late binding and have therefore declared the slide and shape as objects.

Please Login or Register  to view this content.

[G.Bregvadze]

Thanks a lot for supporting, works great.