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 reply

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