Hi,
I want to create a macro that whenever is run it will look into a specific folder and it will search for certain files and then load them back to excel.
e.g. I will have a list in excel such as:
photo1.jpg
photo2.jpg
photo3.jpg
In the excel file I will also specify the folder location e.g. C:\\User\Pictures
What needs to be done then is for the macro to go into Pictures folder specified above, find photo1 and if it finds a match then load the picture in excel.
I know how to create loops and everything in order to do it for the whole list but I just need help on how to perform the search and load part.
Thanks
Bookmarks