Mar 28 2022 11:29 AM
Mar 28 2022 01:42 PM
Mar 29 2022 09:53 AM
The short answer, of course, is yes you can do that.
The long answer is that it will require VBA and functions that can enumerate files in a folder (preferably using FileScripting, although old school Dir is feasible). Then, once you've created a list of those files in a temp table, you can loop through the list importing each one in turn.
However, it also depends on WHY you need to do this. If the files are constantly being replaced by an external process, such as output from a testing station, or orders from an online store application, then you can't just link to them and use them that way, not easily at any rate.
I believe that at least two of the projects I completed for clients over the years would be similar to this, but each involves multiple, significant VBA functions and subs and would not be something easily passed through a forum.
So, define the nature of the requirement a little more fully and we can maybe offer more ideas.
Mar 29 2022 01:09 PM
Mar 29 2022 01:10 PM
Mar 29 2022 11:14 PM
Mar 31 2022 02:32 PM - edited Mar 31 2022 02:46 PM
@George Hepworth After I finally located a back up of the relational database application to which I referred earlier (it was in the wrong subfolder of a backup drive), I realized that it is even more complex than I'd recalled, so much so that trying to provide it as a template seems to be hopeless overkill. I'm sorry I got your hopes up. It would take hours to even cut it down to an example that might be usable.
That said, I didn't just want to drop it. Attached you'll find the core module that explores one or more folders and any subfolders in them and returns a list of files found.
As you can see, it's not a simple matter and I don't have time to put it into a more generic form.
I know that's of little help, but it's about the extent of what I can offer. Perhaps someone has an already simplified procedure to share.