+ Reply to Thread
Results 1 to 2 of 2

Macro to insert an image in comment

  1. #1
    Registered User
    Join Date
    04-12-2013
    Location
    asortsdcolchis
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Macro to insert an image in comment

    I would like to insert a jpeg image as a comment in a cell that has the same word as the jpeg filename.
    pls help...

    to be clear:
    1)I have a cell named "mango"
    2)I want to insert "mango.jpeg" as a comment onto the same call from location "c:\picz"

    Pls help wid a macro for the same....

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

    Re: Macro to insert an image in comment

    This code uses A2 as the word to use in the picture file.
    The code does work, just make sure you have all the addresses and Formats correct, A2 will only have the word not the suffix.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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