Look for 'text' in column, check if image exists and create hyperlink?

This may be a macro question but I've been driving myself nuts trying to figure it out so I find myself on this forum. What I'm trying to do is this;

Look for 'text' in a column, check a specific folder to see if an image exists with that same 'text' in the column, and if so, create a hyperlink to that image.

Example:

Column #1
001
002
003

Check field '001' to see if a file called '001' exists in "C:\images\". If it does, create a hyperlink in that field to point to "C:\images\001.jpg".

Is this possible? I'd appreciate any and all help!

definitely need some VBA for the file exist checking

check this link for the file checking
http://vbadud.blogspot.com.au/2007/0...existence.html
**i have tested this and it works

hyperlink() function for the rest

the way i set it up
column A is your data
column B is combination of directory and adding .jpg

Please Login or Register  to view this content.

column C is combination of the above function and if statement

Please Login or Register  to view this content.

Column D is

Please Login or Register  to view this content.

I managed to get it to work with a bit different vba code. But now I'd like to have the hyperlink ("Click") show up in the next column over instead of overwriting the text in the initial field it is checking and matching an image up to. Any ideas?

Please Login or Register  to view this content.

Moderators note: code tags added for you - this time

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Please Login or Register  to view this content.

change your anchor