display file dialog box with VBA

VBA code to display file dialog box that you can select a file:
Dim Fname As String
Dim da As FileDialog
Set da = Application.FileDialog(msoFileDialogFilePicker)
da.show
Fname = da.SelectedItems(1)
Msgbox Fname

Posted by: Lavy | post date: 12-27-2012 | Subject: VBA for MS Access




    This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
    C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.