ferocious12
Member
Hi All,
I have name of the picture in column A (it can be either Hyperlink or plain text). The corresponding pictures with same name are saved in hardrive at location "C:\Users\Zeb\Downloads".
What I want is VBA code
- search for the name of picture in above hard drive location and insert it in corresponding cell in column B and
- resize the picture to height 1.3" & width 0.83" and
- resize the row width 99
I have attached the sample output file. Any help?
Thanks
I have name of the picture in column A (it can be either Hyperlink or plain text). The corresponding pictures with same name are saved in hardrive at location "C:\Users\Zeb\Downloads".
What I want is VBA code
- search for the name of picture in above hard drive location and insert it in corresponding cell in column B and
- resize the picture to height 1.3" & width 0.83" and
- resize the row width 99
I have attached the sample output file. Any help?
Thanks