+ Reply to Thread
Results 1 to 3 of 3

Macro to insert pictures based on values

  1. #1
    Registered User
    Join Date
    08-04-2016
    Location
    Mogadishu, Somalia
    MS-Off Ver
    365
    Posts
    2

    Macro to insert pictures based on values

    Good day,

    I am new to VBA and have managed to get this code together to insert pictures based on values in cells.
    It is working but when I share the file, the pictures are not displayed.

    Code below:


    Please Login or Register  to view this content.

    The code is working but when I send the file to other users the pictures are not displaying.

    Seems that the pictures needs to be embedded into the sheet.

    Any help would be greatly appreciated.

    Kind regards
    Atto
    Last edited by davesexcel; 09-18-2020 at 01:39 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Macro to insert pictures based on values

    That's strange. Can you attach a sample to see it has a picture?


    Can you also clarify that your office version is 3.11?
    Last edited by davesexcel; 09-18-2020 at 01:46 PM.

  3. #3
    Registered User
    Join Date
    08-04-2016
    Location
    Mogadishu, Somalia
    MS-Off Ver
    365
    Posts
    2

    Re: Macro to insert pictures based on values

    Hi Dave,

    I have Office365, profile updated now.

    Please find the test file and sample photos attached.

    When opening the file, the photos will not be displayed.

    Kind regards,
    Atto
    Attached Images Attached Images
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to Insert pictures between two files based on Cell Values
    By rehana402003 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-05-2019, 01:56 AM
  2. Macro: insert pictures based on URL - how to only get pics of newly added URLs
    By SHI.NL in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2018, 09:12 AM
  3. [SOLVED] how to insert empty rows based on column B cell values and paste above values with macro?
    By genetist in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2018, 11:47 AM
  4. Macro to Insert Pictures into column based on cell value
    By lyla22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-13-2017, 03:25 PM
  5. Insert pictures in cell's comment based on filename
    By mattin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2014, 10:17 AM
  6. Insert pictures with a macro
    By pmlv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2014, 11:56 AM
  7. Replies: 1
    Last Post: 03-14-2014, 06:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1