How to Browse for a file from within a userform

This is a copy of a thread started in the wrong (Formulas ) section of the forum. I hope I am not breaking forum rules by trying to correct this.

I have the following piece of code to pick up a known file name and open it.

Please Login or Register  to view this content.

This was derived directly from a macro generated from browsing my network.
What I really want to do though is to enable my user to find the file using a browsing routine direct.
I have not been able to find any advice about this and am hoping that someone here can help.
John