macro: insert muliple images and resize into given cells

[marco83]

Hi All,


please help complete newbie how to create and instal macro in excel.



The file is just a pricelist that will be updated weekly. There is already formula working on it and now needs only insert resized images. Assume images are stored C:\images. Column A is unique code of product 123456. Column N is called Image and needs automation insert files from given path matching code from A column for each of 1000 records. Assume files on disk are 800x600 and needs to be resized and fit cell 70x22 (Row height x column widht). Files will be named 123456 etc.
Need macro to be visible only on my machine, not to be saved in workbook and send further.



for many of you probably simple, for me rocker science. Thank you for help in advance