batch insert graphics into excel using VBA
Posted on 2013-11-12
I wonder whether the following is feasible using VBA
I got a product list with the following make-up
item-no description path graphic
17-15 myproduct1 C:\test\myproduct1.tif graphic to be inserted
17-17 myproduct2 D:\myfolder\myproduct2.tif graphic to be inserted
17-19 myproduct3 C:\test2\myproduct3.tif graphic to be inserted
The graphics are not located in just one folder but are scattered in many different folders.
I wonder somebody is able to come up with a VBA solution.
I know that this should be done using excel as a data source and doing a mailmerge using word. This works just great. I have worked with that approach dozens of times, but this time the requirement is to do this directly in Excel.
Thank you very much in advance.