Stuck in VBA

You can use the DIR function to check the image exists before trying to load it to the image control, or use formal error handling - which should be included with any non trivial code in any case.

I've kinda new to VBA and never used the DIR function before. But I'll google that one. I tried the error handling but that doesn't do what I want so far

I tried the error handling but that doesn't do

Then post the code you did use for the error handling...

This is the main line:

url_path = rName.Offset(0, 37).Value
file_path = ThisWorkbook.Path & "\" & "Image.png"
' Download picture
DownloadFilefromWeb url_path, file_path

When there isn't a picture, it should follow this line:

On Error Resume Next
url_path = rName.Offset(0, 39).Value
file_path = ThisWorkbook.Path & "\" & "Image.png"

I tried it with this, but that doesn't work...

url_path = rName.Offset(0, 37).Value
file_path = ThisWorkbook.Path & "\" & "Image.png"
' Download picture
DownloadFilefromWeb url_path, file_path
On Error Resume Next
url_path = rName.Offset(0, 39).Value
file_path = ThisWorkbook.Path & "\" & "Image.png"

You also could use file attributes to check if file exists

Please Login or Register  to view this content.

'On Error Resume Next' is NOT error handling - it is simply ignoring any errors that are raised and really should not be used unless you know exactly what you are doing and are coding to resolve any errors that are raised.

Read the link in my first post.

Thnx a lot Cytop!
I read the article and learnt a lot. I found out that the first part results in a Error (I can't figure out what goes wrong) so I switched the two parts and now it works fine (with the on Error resume next :-) ).