Previous Topic Next Topic

How to insert & resize picture automatically

Closed
DK Dhir Posts 1 Registration date Wednesday February 6, 2013 Status Member Last seen February 6, 2013 - Feb 6, 2013 at 03:17 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Feb 6, 2013 at 05:42 AM
Hello,



Sir I have an Excel 2007 file named "DTPH.xlsx" with data having person names, details in column "A to K". I have to insert the person pictutre in column "M" with the data. In the datasheet column "L" I have entered the picture file names also. I am inserting the pictures manually from a particular folder "D:\pictures". Do you have any macro program for inserting pictures from that particular folder to the data sheet.

Awaiting for you reply, Kindly send me the solution at : E-mail deleted for security reasons by your friendly neighbourhood moderator

Thanking You
DK

1 response

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Feb 6, 2013 at 05:42 AM
Hi DK,

Please check the below mentioned link, it explains how to insert pictures in a worksheet using a Macro:

https://ccm.net/faq/14170-excel-a-macro-to-insert-pictures-in-a-worksheet

Please reply if you have any further questions.
0