At the moment I am using code to loop through all Excel files within a folder and perform a macro on each one in turn.
In addition to this, I want to be able to move each file into a specific folder based on their filename.
So within an excel macro, is it possible to move a file into a specific folder if it contains the word "Bankhill" for example?
All files containing the literal "Bankhill" in their filename would go into the "Bankhill" folder, all files containing the literal "Lite" in their filename would go into the "Lite" folder etc...
I have tried doing something similiar in VB.net and also with some windows scripting languages but I haven't really got anywhere, in any case it really needs to be executed from Excel so it works in conjunction with all my other macros.
Hope someone can help me out with some code? This is really holding me back from creating an effective automated system...