How to insert & resize picture automatically

[Closed]
Report
Posts
1
Registration date
Wednesday February 6, 2013
Status
Member
Last seen
February 6, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
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.