N/APosted on - 11/03/2011
Hello! I want to use VBA to pack an image into a picture placeholder; the aspect ratio of the image and the size of the placeholder should be intact. The image is resized on selecting “Fit” on the Crop tool; however the picture has to be manually put into the placeholder. At least one measurement is ranged to the maximum of the placeholder while preserving the aspect ratio for the other measurement. I need to have that recurring in VBA. Who can avail me VBA codes to solve my dilemma? VBA version is PPT 2010. Please help me… Thanks…
Who can avail me VBA codes
To be able to use the visual basic application code in the application you are using, which you should have mentioned to start with, you will need to access the visual basic editor. I am guessing that since you are talking of inserting a picture in a place holder you should be using a program like ms word or Ms PowerPoint. So to access the visual basic editor you will just have to press ALT+11 on your keyboard and then insert the codes as a module.
As for the code itself, I will refer you to the following site so that you can have a look at a code that I believe will just help you out with your problem. The code is a bit lengthy and I do not want to break it to you in pieces:
Hope this helps.