Open dialog with all files listed, then the selected file to open

this code opens with All Excel files shown (I Want to view all files), however it does open the selected file.

Please Login or Register  to view this content.

This code extracted from http://www.excelforum.com/excel-prog...all-files.html
Opens the dialog window as required, but doesn't open the selected file.

Please Login or Register  to view this content.

Please supply changes to either method to open with all files shown, and then enables the file to be opened.

Thanks humdingaling
The act of posting after a couple of fruitless hours once again did the trick as well.
I used this

Please Login or Register  to view this content.