• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Inserting pictures from hard drive in excel

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
 

Attachments

  • Rudra.xlsx
    48.8 KB · Views: 4
Hi,​
use the Dir VBA function to check if the file exists then use the appropriate method​
as you can see just activating the Macro Recorder and operating manually to insert and resize a picture …​
 
Back
Top