I have a form that a user uses to upload a CSV file. Right now the user has to type the full file path of the file into a text box. How can I get a browse for file popup to allow the user to navigate to the file instead of having to type the whole path? Is the functionality already present and I just don't know how to use it yet?
Asked
Active
Viewed 312 times
4
-
1look up File Picker dialog box – Colin D Apr 10 '12 at 19:38
-
3http://stackoverflow.com/questions/4813598/using-the-browse-for-file-dialog-in-access-vba – Jake Toolson Apr 10 '12 at 19:41
-
Thanks for the response I will take a look at both. – Tommy Johnson Apr 10 '12 at 19:45
-
3possible duplicate of [How to show "Open File" Dialog in Access 2007 VBA?](http://stackoverflow.com/questions/1091484/how-to-show-open-file-dialog-in-access-2007-vba) – Fionnuala Apr 15 '12 at 16:15
1 Answers
2
you can create your own class with API calls. Here you have the code. Or you can add a reference to Microsoft Office xx Object Library and use the FileDialog class. Here you have an example of usage.
I prefer the first method, because you are not attached to an external library.
