I am new to VBA but I do have an understanding of the code. Here is what I want to do:
The user clicks the main folder called XML. There are twenty folders in the XML tree (e.g. XML/Code/Programs/Data/Software/Files/etc.) and each folder contains a number of files consisting of txt, jpg, doc, xml, rtf, etc. The user wants all of the XML files from each folder in the tree to import into Access. I am looking for code that will allow the user to click the main XML folder and automatically search, find, and export all XML files from the rest of the folders in the tree to Access. Is there any code available that will do this or does anyone out there know how to do this?