+ Reply to Thread
Results 1 to 3 of 3

Naming an embedded image while it is being added to the active sheet

  1. #1
    Registered User
    Join Date
    05-08-2013
    Location
    Monterey, California
    MS-Off Ver
    Excel 2007
    Posts
    40

    Naming an embedded image while it is being added to the active sheet

    I am using a loop to import 75 different images into an active sheet.

    Please Login or Register  to view this content.
    The images are called Pic1.png, Pic2.png - etc. When they are embedded into my activesheet however, excel names them Picture 1, 2, etc. But their (excel's) naming is not consistent...
    How can I name the images as they are being added to the activesheet? I would like to give them a name like Icon1, Icon2,.... Icon75 so I can call them out from another loop.

    Any help would be greatly appreciated! Thank you.

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Naming an embedded image while it is being added to the active sheet

    You can try

    Please Login or Register  to view this content.
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    05-08-2013
    Location
    Monterey, California
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Naming an embedded image while it is being added to the active sheet

    Ollie - THANK YOU SO MUCH!! I was looking everywhere and this works very elegantly and simply. You totally made my day!

+ 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] VBA to send embedded image in email body- NOT USING THE ORGINAL IMAGE SOURCE
    By Coreyusa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-27-2013, 06:48 PM
  2. Outlook Embedded Image - Red x
    By VillaLion in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-16-2013, 07:02 AM
  3. Embedded image
    By jclayland in forum Excel General
    Replies: 2
    Last Post: 04-17-2008, 07:28 AM
  4. [SOLVED] How to produce(move) an embedded image using a formula?
    By rbs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-26-2005, 10:05 AM
  5. How to make chart embedded in active sheet?
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-09-2005, 03:05 AM

Tags for this Thread

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