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
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
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:
usage:Please Login or Register to view this content.
Formula: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.
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.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks