+ Reply to Thread
Results 1 to 2 of 2

VBA to import and embed images into Excel

  1. #1
    Registered User
    Join Date
    10-08-2017
    Location
    Orange County, California
    MS-Off Ver
    Office 365 E3 License
    Posts
    1

    Question VBA to import and embed images into Excel

    Hello everyone,

    I am new to the forum and have done a search already and I haven't found what I'm trying to do unfortunately. My VBA skills aren't great and it's been quite a while since I have done anything with VBA. However, I'm an IT support specialist and my sales department wants an Excel spreadsheet that when they type the part number into one column, the column to the right is being generated with the image of the product corresponding to the part number. The nice part to this is that the file names are the part number. The not so nice part to this is that the photos reside on a network area storage, specifically a cloudstation synology storage, but will eventually move to OneDrive in about a year.

    So there's my little schpeal on what I am looking for, and any and all help would be greatly appreciated. Can't thank some of you forum folks enough (in general), you people are quite the best.

    Regards,

    zeroLOOKUP

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,143

    Re: VBA to import and embed images into Excel

    Ignoring "a cloudstation synology storage" (in this particular case I don't know) it is not difficult to make such a preview.

    Example (with two variants: macro and functions) below:
    File directory to paste into e.g. "c:\temp\"
    If "PicLinks_01_eng ver.xls" will be in the images directory, it will automatically recognize them
    Up to 4 images can be displayed for each part
    Red font - actions from vba code
    Blue font - actions from function "HYPERLINK"

    ps:
    They may occur errors (in the translation of the functions) though they do not have to.
    Sorry for bad english
    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] Embed Images in Cell Range from File Paths
    By JustMark in forum Excel General
    Replies: 2
    Last Post: 04-17-2017, 08:47 PM
  2. [SOLVED] Embed multiple images from local path
    By leoxanigm in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-26-2016, 03:53 PM
  3. [SOLVED] Copying Excel Embed Images in Excel itself
    By Nevermore97 in forum Excel General
    Replies: 4
    Last Post: 09-28-2014, 12:55 PM
  4. Replies: 0
    Last Post: 11-08-2013, 04:42 PM
  5. Embed Images in multiple files
    By BTerrell721 in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2013, 12:50 PM
  6. Embed Images in excell from UNC path
    By netsrule2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2008, 11:34 PM
  7. Replies: 1
    Last Post: 06-23-2005, 07:05 PM

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