Upload files in excel

What I want to do is allow users to select a file by clicking on a button then the file browser will popup. When they select a file it will return the file path to the cell "PDESC". Later on this file path will be used to attach the file to an email in the email script.

Currently as you said the code I have allows you to select a folder but not a file within a folder and so it only returns the directory path, I need to return the full file path.

Also to cofirm, in my email script if I use the cell "PDESC" as the file string for the attachment, will it work and attach the file? The file could be in any format.