Save images from excel file VBA
Hi experts,
I have an excel file with images in column A and text to become image names in column B.
This code allows me to save all images from excel in .png format to a selected folder which is great.
The issue I have is after image gets saved, it is very small. Is there a way I can save images in smaller power point slides so I wont have so much white space around it? (Image with this issue attached). Thanks!
Please Login or Register to view this content.
You could try the below subroutine, which I've adapted from my Access code. It uses chart objects instead of PowerPoint, so the image dimensions are the same as the source instead of pasting onto a slide.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks