Who can avail me VBA codes

Asked By delmare 0 points N/A Posted 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…

• Status: Open
• Question Views: 885
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Mahesh Babu 20 points N/A #105034

Who can avail me VBA codes

Hallo Delmare,

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:

https://support.microsoft.com/en-us/help/168649

Hope this helps.

__

Regards

Mahesh Babu

 

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/24/2011
• Question Category: Visual basic