If you use the File System Object, you can among other things ask it to TELL you how many files are in a given folder and THEN ReDim your array to the correct size initially. You have also been told how to constructively ReDim your arrays from static's post.
I have three college degrees in the field and I've been doing this stuff for 30 years
Shaming others or brow-beating them or turning towards
argumentum ad authoritatem as a bludgeon doesn't help. I have been active in the computer industry for 42 years as a professional plus another 5 years of work while in college doing real-time on-line experimental data acquisition for millisecond events, working at the device-driver level. I know my way around a machine. I have a Ph.D. (hence the "Doc" in my name, it's not just vanity). I have taught college level courses in my field. I have taught database classes (not for Access, it was before that came into being) and I have taught Windows Security classes to government system administrators. Your demeaning attitude of "I'm a seasoned professional, don't try to teach me something I already know" just ticks me off.
I see in you an arrogant attitude that is preventing you from seeing the simple solution. If you actually KNEW this stuff, you could step away from the curb, get a cup of joe, munch on some chips, and calm your fevered brow. With a calm head, all those things you claim to know should come back to you. Our hints should have struck a chord for you.
vShane, you also should consider the possibility that you are doing something that not many of us do, so if you don't get a snippet from us, maybe it is because you are off in a direction we don't go. To then chastise us because we are all "Left Twix" while you happen to be "Right Twix" just isn't polite.
We also don't always post code snippets because too many kids try to fake us into doing their college homework for them. Since we don't get the grade or the degree, we don't always offer up code. By giving directions but not free code, we protect ourselves in a way. If you ARE legit, the hints are all you need. If you are a school kid trying to coast through a project, the hints will point you in the right direction but you still have work to do. And remember, from words on a screen, we can't tell which one of those you are.
We are all volunteers here. We help those people who need our help if it happens that we have the required expertise. Copping an attitude isn't cool.
