Image Not Found

[millzner]

Working on an excel VBA application that I can enter a ID Number and will return employee info, including a Picture into excel worksheet. I can do all of this fine. What I need is any easy way to get the program to continue when there isn't an image of the employee on file.

Any thoughts??

 

[BrianB]

Have a look at my code 'Private Sub FindValue()' here

http://www.mrexcel.com/forum/showthread.php?t=144226

 

[millzner]

Read through the Post and unless I read it wrong it looks for values using a Userform Interface and returns values from cells. I am doing almost the identical thing but here is my problem. I have 6 columns of data, Column A is the Employee Number, and Column F is the employee Image File Name. The employee number would be something like 123456 and the Image would be 123456.JPG. The problem is that there is a chance that the image 123456.JPG does not exist in the folder I have and would like to be able to continue with the program without crash and maybe insert a default image. I can do this if the Image cell was blank but can't figure out how to do it with values in all the cells.

And if this code was in your post I appoligize for missing it but I didn't see that.

 

[VoG]

Perhaps

On Error Resume Next
'
'code to retrieve picture
'
On Error GoTo 0