Hi All,
I have student ID's in column B, file path of students' pictures in column C. I want to show the picture of student in column J. Picture name is same as student ID in column B (e.g if student ID is 1005, it's picture name is also 1005 in specified folder). I also want to set picture size equal to the size of cell in column J.
I have search the web and tried many solutions but could not get the right way.
I hope here the gurus can solve it.
Regards.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
File is attached and requirement is explained in that file.
Thank you for your time and effort.
Hi User3,
Try this:
Please Login or Register to view this content.
Last edited by xladept; 05-05-2015 at 03:36 PM.
Hi xladept,
I have applied this code and it give error msg "400". Can you please apply it in file and see if it works.
Thank you.
I have also found a code from searching internet, can u see what amendments could be made to apply this in my workbook. Cell and column references are also to be adjusted.
Please Login or Register to view this content.
I made a small change and it works on a png image for me:
Please Login or Register to view this content.
Hi xladeptOriginally Posted by xladept
I made a small change and it works on a png image for me:
Please Login or Register to view this content.
I have tried this code. It inserts first pic in cell Y5 so many times and leave other cells below blank. It also makes my file busy as something is still in process and in few seconds Excel title bar shows "Not responding", so I have to forcibly close it.
What's the matter in it? Can you please resolve it.
I have attached the file after running the code you can see by dragging the pic that cell Y5 has so many same pics and below cells are empty.
Code should see the ID's available in col D and should insert only as many number of pics as many ID's are available in col D to consume less time. Please make one more amendment that code could work for all types of images not only PNG because some pics do not have PNG format in specific folder.
Thank you for your time and effort you are putting for me.
Regards
Last edited by User3; 05-07-2015 at 02:40 AM.
Oops! My Bad - I forgot to increment the index - sorry:
Please Login or Register to view this content.
Hi xladept,
This code is working nicely. Only one problem is there that it gives error "400" when one or more pics are missing in relevant folder. Please make amendments so that it could ignore the missing pics and insert only available pics.
One more thing when code is executed it should first remove previous pics from cells and then insert new ones because I have to change the list of ID's again and again and need the code to insert new pics.
Thank you for your work for me.
Last edited by User3; 05-08-2015 at 06:34 AM.
I'll look at it again tomorrow
For some reason, I only saw this post after you PM'd me
Try this:
Please Login or Register to view this content.
Thank you xladept,
Matter is resolved... I'll in touch through this post if any problem arises.
Thank you again for your work.
Excel tips @
www.fb.com/businessexcel
You're welcome and thanks for both the rep and the compliment!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks