"OpenFile" Code Cleanup

[Mordred]

Hi all,
I am currently tweeking my VBA for work. In one macro, I've prompted the user to enter the name of the file to open. I've then passed the name into a function that opens it if it is there or display an error message if it is not. I works just fine but I was hoping that a VB pro could tell me if I've done it right. Here is the Function:

Please Login or Register  to view this content.

Once this is passed and returned to my other macros, I have this:

Please Login or Register  to view this content.

Is this okay?
Any insight will be truly appreciated.

Regards:

[shg]

Maybe like this:

Please Login or Register  to view this content.

[Cutter]

A minor point: you have a double "the" in your msgbox message.

"Please rerun the the update and enter the proper filename"

[Mordred]

Haha, thanks for point out the 'the the'. I'll take care of it.

[snb]

Wouldn't this be simpler and replace the whole function ?

Please Login or Register  to view this content.

[Mordred]

Wouldn't this be simpler and replace the whole function ?

Please Login or Register  to view this content.

This goes straight to Exit Sub, even thought the file is there.

[snb]

I don't think so.