Pull pictures from folder to excel sheet...HELP

I

iowitz

New Member
Joined
Nov 19, 2013
Messages
17
I have an excel sheet where column B has a list of product codes. I also have a folder with pictures of each product and file name of the pictures are the product code. I would like to place the picture of each product in column A beside their respective codes. If possible, I would also like to reformat the pictures so they fit in the cell. (3.00 x 3.85)

Need a Macro that can run this.
I don't really know where to start and any help would be greatly appreciated! thanks
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

KlausW
  • Solved
Excel VBA Error - Unable to get the Insert property of the Picture Class
Replies
7
Views
343
KlausW
KlausW
T
  • Question Question
VBA Macro to autosize Comment with picture
Replies
1
Views
73
Domenic
D
H
  • Question Question
Help - #unknown! error after adding pictures.
Replies
1
Views
1K
myall_blues
myall_blues
A
  • Question Question
How to Unlink an Image/Picture in a spreadsheet to its original path
Replies
7
Views
309
Abegail0203
A
H
  • Question Question
Based on Multiple Criteria Pick data from Total Sales Row
Replies
7
Views
313
NickFru
N

Forum statistics

Threads
1,223,885
Messages
6,175,184
Members
452,615
Latest member
bogeys2birdies

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top