Finding a file and displaying message

[Loughsie]

I need to edit a macro that opens a file that is as .csv

what i want is if the user incorrectly places a file in folder F:\report as .rep

then i want the user to see a message that advises them of the correct format and re run

file name is opened

start of macro is Workbooks.OpenText Filename:= _
"F:\Opened.csv",

if the user put a file name opened.rep i want them to see a message

ive been messing around with a few IF statement but can seem to get it right

anyone any ideas please

 

[QuietRiot]

may seem too basic

couldn't you just put a on error resume next above the open code

or on error goto message


then have a message saying:
message:
Msgbox "Couldn't find Opend.Csv, please make sure it was correctly saved in the right format"

 

[QuietRiot]

on error goto message
Workbooks.OpenText Filename:= _ 
"F:\Opened.csv", 


goto theend
message:
msgbox "couldnt find file etc"
theend:
end sub

 

[Loughsie]

ok yeah sort of what i was thinking of just i wasnt getting code rite ..thanks ill give it a go