First off, thank you all for your assistance.
@guessed...
I had a question about the fso.GetFolder. If I were to add a block of code after the For loop, and changed the mySource to
Set mySource = fso.GetFolder("C:\Users\rmoyar\Desktop\TestEnviron ment\Macro Testing\Test 2")
And then reran the for loop, would that produce the same functionality after completing folder 'Test 1' for 'Test 2'?
I think you and I were having the same ideas. I was planning on making it work for one, and then calling separate subs for each task. Was planning on making an array that would house the paths of each folder location, and step through that (let's say in a k variable incremental fashion), and pass that back as the variable mySource in the future development, and then in the main sub would call another sub, call it the 'loopSub' that would do the For each file in mySource.Files.
this is certainly exciting for me, as it is well beyond capabilities I have done before, and I am more in favor of learning how it works so that I may apply these skills to other things more readily. I saw the plug-in that @gmaxey mentioned, and again, I think I would prefer to learn myself (may in the future recommend this to others, but for now just wanted to take this as an educational opportunity).
Again, thank you all!
TL;DR version - if I have another line that is mySource = fso.GetFolder(<Test 2\>) will that then process Test 2 files after Test 1 is completed?
|