satyen
04-16-2008, 03:16 PM
I have different excel spreadsheets that will be in a directory i.e C:/Files/ folder. I will need to do different things with a lot of the files.
e.g. All files beginning with "THER " will be of one kind. All files beginning with "APP" will be of another kind. There will about 20 other formats.
Basically I need some code to loop through a specific folder that will pick out if the file begins with for example "THER" and then action some code. The code to action will depend on which file it has detected.
CASE would be the best way and efficient way of managing the code I believe. Can anyone help?
e.g. All files beginning with "THER " will be of one kind. All files beginning with "APP" will be of another kind. There will about 20 other formats.
Basically I need some code to loop through a specific folder that will pick out if the file begins with for example "THER" and then action some code. The code to action will depend on which file it has detected.
CASE would be the best way and efficient way of managing the code I believe. Can anyone help?