Originally Posted by
davesexcel
Maybe update your example to explain what it is supposed to do, then delete evrything that has nothing to do with your question and attach the workbook again.
I found another approach that I am trying. I need a macro to look up the name of the file in column O and then look up the location to insert the file in column N, and then go to a folder and get the picture, and then insert the picture (resized) in the location in column C that is listed in column N and then repeat the process.
I tried to adapt the previous macro that someone else posted, but I get this error when it runs:
Run-time error '1004'
Application-defined or object-defined error
Here is the macro:
You can download the new zip file at: http://www.curtwatke.com/downloads/Desktop.zip
Bookmarks