VBA Multiple image insert MACRO from file folder.

Hi All.

I am desperate to get a macro sorted for a quotation PDF I am using.

I need to insert multiple images from a file folder saved with the specific names of the item.

I.E.

A2:E3 (MERGED CELL) Will contain an item code. The image for this item code is saved in a folder with the same file name.

I need the image to appear in B6:D16. (MERGED CELL)

I then need this to repeat for the remainder of product codes and images.

The product code appears in every 18th Row so the next is A20:E21 and A38:E39 so on.

The images need to appear in every 18th Row so the next is B24:D34 and B42:D52 so on.

I am ok to re size the images, just need the placement sorted in the specific cells.

Please help.

Matt.

Hi AlphaFrog.

Firstly, Thank you so much for your speedy response. I really do appreciate it.

Secondly, It has worked for the first image but does not repeat on to the next images..... Is there an easy fix for this?

Cheers in advance, Matt.

Hi Yes.

So next item code cell is A20:E21 and image should appear in B24:D34.

Product codes match image names exactly. All images are JPG.

Sorry buddy, I hope its not me doing something wrong....

Matt.

It did for me. Here is my file so we can compare apples to apples.

Guys,

I cant thank you all enough. It works really well.

I don't know why it didn't work first time, maybe something to do with the module I set up but it definitely works now for all 1798 lines.

Thank you all again. I really appreciate it.
Matt.