Folder Dialog Option

[bdthomas02]

Hello everyone,

I am very good with Access and I know VB (I am not an expert but I understand the code). Here is what I am trying to do with less code as possible:

1. I want to create a button in Access that will allow me to navigate to a folder (the folder is located in a tree three or four folders down) using the folder dialog option. I do not want to use the commondialog button but would rather hard code if possible.

2. Once I locate the folder I want to click the folder and automatically import certain files that are in the folder into Access. The folder will contain files such as jpg, doc, txt, xls, xml, and gifs. I only want to import all xml files into Access.

Is there a simple and quick way to do this? I need to be able to use this in other projects as well.

Also, I want to call this procedure from a module.

Thanks to anyone who can help me with this issue.

Thanks,

bdthomas02

[Ed Jobe]

Access has some objects in that area. You can also use Windows dialogs. Search this forum for FileDialogs. It is a class module you can import into your project. It has File open, save as and folder browser dialogs.

If you don't need the user to interact with dialogs, just use the vbscripting FileSystemObject. Look in vb help for that.

[bdthomas02]

I am new to this forum. Where do I go to search for the information you provided in your response?

[Ed Jobe]

Look at the top of this thread. There is a "search this thread" link. Above that is a "Search" link and to the left of that are links to the parent forum. Navigate to that, the "VBA" forum, and there is a "Search this forum" link. You can also do this from anywhere using advanced search.