run time error 75 = LoadPicture(ThisWorkbook.Path & "\" runtime

[excelconditional]

Hi All,

A working form that I put together is displaying a Run Time Error 75, which is pointing to the file path of the images: The code is:

Please Login or Register  to view this content.

The images of the employees and the Workbook are within the same folder.

The names being referenced where written in non English characters originally, but for some reason the Excel 2016 version I'm using has gargled up the employee name characters within the VBA code..

Can someone help?

[Marc L]

Hi !

Check first the filepath with the VBA Dir function : if the file exists, this function returns its name, if not the string is empty …

[excelconditional]

Hi !

Check first the filepath with the VBA Dir function : if the file exists, this function returns its name, if not the string is empty …

Hi Marc,

I've just done a google search but there are many bits of code floating around. Could you post a snippet of code for me to run?

[Marc L]

As all the necessary is yet in the VBA help …

Anyway a sample with the string variable F for the filepath : If Dir(F) > "" Then Image2.Picture = LoadPicture(F) …