How to insert images to my excel sheet by using a Macro [Closed]

Report
Posts
4
Registration date
Thursday November 6, 2014
Status
Member
Last seen
November 11, 2014
-
I have my huge files and below is a sample.

I need to add photos for everycode in coloumn "A" to the same row coloumn "E"
and I want to run a macro to add photos just after I filled up the codes coloumn and other necessary information.

Lets say image files are found in "D:\images\" folder with the same names mentioned in coloumn "A"

Besides when I add the photos I want the images to be 4,6 cm height plus pictures should be placed in the center of the cell and I need the cell height to be arranged automatically also which will fit to pictures height.



Anybody can help? for this VBAless guy? :)

Thanks.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!