If file does not exist, msgbox

[StevieT2301]

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.

[Norie]

Perhaps.

Please Login or Register  to view this content.

[AlphaFrog]

Hi and welcome to the forum.

Try something like this...

Please Login or Register  to view this content.

[StevieT2301]

Thanks guys, appreciate the prompt response. Both worked perfectly!