Insert multiple pictures using VBA referencing file paths

Hello,

I am new to both the forum and world of coding. I have multiple file path names I am trying to automate either the replacement of the paths with the photo or inserting the photo in a new column (either will suffice). The photo file paths are listed in columns C2 - C312. Does anyone know a code that will automate this for me?

Thanks!
Nick

Welcome to the forum!

Did you want links for smaller files or full embedment? If the latter, add code below to a Module and run with the sheet active.

Change path to files and the file extension JPG to suit.

Please Login or Register  to view this content.

Thanks Kenneth!

Will this code replace all file paths in each row under the same column (C), or 1 at a time? That being said, I could not get this code to run correctly. The sheet was active and this is an example of what the code looked like once I replaced file path and JPG:


module_1.PNG


I know there is probably something simple I am not doing correctly but could you tell me what is wrong with the code?

Thanks!
Nick

Why did you add IMG_0097474.jpg and not use .jpg? Is that a suffix where you first cell C2 is say ken the the filename kenIMG_0097474.jpg exists in your folder?

IF you comment out the ON ERROR link, you can see that it is probably failing because none of the filenames exist.