This is my first post, I would greatly appreciate some assistance with a particular requirement I have to automatically insert photos into cells in Excel 2007.
I have searched these forums and others and can't quite find what I am looking for.
This request may sound a little odd, but its to enable me to print a particular report.
What I'm looking for is a macro that looks for the filenames on any row in either Columns "A", "B" or "Q", and then inserts the picture into the same cell where the filename was found.
So if "picture 1" is in cell A15, then I would like picture 1 to be inserted into cell A15. If "picture 27" is in cell Q268, then I would like "picture 27" inserted into cell Q268.There will not be any pictures beyond about row 2000 if that helps.
I tried to use a loop, but the catch is that most of the cells in these columns will be empty, so just the occasional filename, that I want replaced with its corresponding photo.
I also would like the ability for the code to specify the size of the pictures (all pictures will be the same size though).
I have searched these forums and found something that does part of what I need:
The major thing thats missing from this code is that it requires me to specify the exact cell to look for the filename.
I found some other code that cycled through a loop, but the problem I found with this was the code stopped when it came to an empty cell in a column.
I would really appreciate some help, many thanks in advance.