VBA Picture Can't Be Displayed Issue & Bad File Name Or Number

[Lewzerrrr]

Hi,

I have a workbook template that you can input a string and it will pull the picture from a directory or internet.

The only issue is when it gets quite bulky, some of them result in a picture can't be displayed but unsure why as if I was to run the ones that don't pull the image one at a time, they'll pull through successfully.

Is it because importing pictures is quite a heavy process?

Is there anyway around this?

I've also encountered a Bad File Name Or Number in the past and some other users have aswell but I can't ever replicate it upon several attempts.

Should I wrap this in an On Error Resume Next, On Error GoTo 0?

It happens on this the bold line below:

Function FileExists(fname) As Boolean

    Dim X As String
    
    X = Dir(fname)


    If X <> "" Then
        FileExists = True
    Else
        FileExists = False
    End If


End Function

Thanks,

 

[mole999]

on error resume next would loop so that it should complete but may not process all files. You might try DoEvents after each import to give excel chance to process for those that require a bit longer