Hi there,

I am looking to build some coding to create a msgbox when a file cannot be found. The actual coding to open the file is as per the below:

Workbooks.OpenText Filename:=Range("I12").Value & "\ACCR_AMEX_VISA_Rates_and_FCR.csv"

If the above cannot be found, a simple msgbox with "file cannot be found" will suffice.

Can anyone help please?

Thank you.