shetlandbob
Programmer
Hi, I'm not sure how to start this one, so any pointers appreciated.
I have a base/home directory say
C:/MyDir
And in this there is a number of sub directorys say,
C:/MyDir/one/
C:/MyDir/two/
C:/MyDir/three/
C:/MyDir/four/
Unfortunately due to reasons outwith my control these sub directorys are not using a sensible naming convention (i'm still not happy about it).
In all these directorys there is files of the format
####.XLS
where #### is a number.
is there an easy way that I can auto search (i.e. find file */*) all sub directorys until I find my file, and return the path.
The way this works is the user sets the base path ( i.e. C:/MyDir ), and then in a text box enters the number and then presses "LOAD". To load the file.
Any help pointers much appreciated.
I have a base/home directory say
C:/MyDir
And in this there is a number of sub directorys say,
C:/MyDir/one/
C:/MyDir/two/
C:/MyDir/three/
C:/MyDir/four/
Unfortunately due to reasons outwith my control these sub directorys are not using a sensible naming convention (i'm still not happy about it).
In all these directorys there is files of the format
####.XLS
where #### is a number.
is there an easy way that I can auto search (i.e. find file */*) all sub directorys until I find my file, and return the path.
The way this works is the user sets the base path ( i.e. C:/MyDir ), and then in a text box enters the number and then presses "LOAD". To load the file.
Any help pointers much appreciated.