Do you have the code to lean to me?
: To Select a Folder --> API "SHBrowseForFolder" --> There are ton's
: of examples on the net.
: To search a Folder tree for files with a specific extension you need
: a recursive search-algorithm. The API's "FindFirstFile",
: "FindNextFile" and "FindClose" are your friends (i remember having
: coded something like this some years ago)
: : Hello everyone,
: : 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?
: : Thanks,
: : bdthomas02
: Only stupidity of mankind and the universe
: are infinite, but i'm not sure concerning
: the universe. A. Einstein