Excel – macros: inserting an image (from jpg file)

Home Forums Office Office XP / 2003 General Issues Excel – macros: inserting an image (from jpg file)

Viewing 1 post (of 1 total)
  • Author
    Posts
  • Avatar
    intersilver
    Member
    #128181

    Hi,

    I’m looking for a way to automatically insert an image into the Excel sheet, depending on a filename which is entered in a different cell.

    For example, let’s say that in cell A1 I type “ABCD” – I want Excel to insert the picture “ABCD.jpg” into cell B1. If I replace the text in A1, it replaces the image in B1 accordingly… etc.

    Would be extremely thankful to anyone who could help – especially if you could show me how to do this with a relative pathname for the image (i.e., the images will be located in a sub-folder inside the folder where the Excel sheet is located).

    Thanks!

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.