+ Reply to Thread
Results 1 to 3 of 3

Auto Picture Import

  1. #1
    Registered User
    Join Date
    02-18-2020
    Location
    Bridgwater
    MS-Off Ver
    2016
    Posts
    1

    Auto Picture Import

    Heys Guys and girls

    I am creating a list of barcode numbers in column1 , with a picture of the barcode in column 2 is there a way to import the pictures just by using the data in column 1 ?

    Thanks in advance

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,738

    Re: Auto Picture Import

    IF each picture of barcode will be named according what contains (ex. barcode picture displayed EAN9888 will be named EAN9888.jpg)
    You can use this UDF:


    Please Login or Register  to view this content.
    usage:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    where:
    A2 - path to file
    N1 - cell where do you want to insert picture (can be itself but can be different, check comments in VBA code)
    50,50 - width & height inserted picture

    Picture is always fit into left/top corner.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Auto Picture Import

    Or if you don't already have the barcodes this will request them from a website.

    I have set it up to run on "ctrl shift Q" hot key to pull up a user form, and by default to run on the selection.
    Attached Files Attached Files
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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. Import picture file name along with photo into cell
    By brundag5 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2016, 01:03 PM
  2. [SOLVED] import picture to fit in merged cell
    By alexshaw76 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-01-2014, 09:35 PM
  3. Import picture to fit in merged cell
    By alexshaw76 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 03:37 PM
  4. How to import picture file from folder using cell value?
    By sukeshparikh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-24-2013, 09:01 AM
  5. Import Picture into Chart in Excel
    By PaulDixie in forum Excel General
    Replies: 1
    Last Post: 06-20-2013, 12:44 PM
  6. How to import picture file from folder using cell value?
    By kaypat in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-30-2013, 05:39 PM
  7. Import web data into excel does not import picture, how to substitute picture for a value
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 03:29 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