Hi all,
A few months back I was fortunate enough to have L.Ross help me put some code
together to which searches for a specific folder by matching a string entry.
http://www.excelforum.com/excel-prog...-wildcard.html
This works great but it is rather limited. The string used for the search either has to be single word or strings consisting of multilple words &/ character groups have to be an
exact match.
I would like to be able to take the search string and parse it to single out each word or group of characters that are separated by a delimiter ( "",/ .)
I have found a parsing function that I would like to use.
http://www.freevbcode.com/ShowCode.Asp?ID=3208
I'm just not sure how to pass the string to be parsed to the function then have the function
return each parsed word or character group to the Function FileFolderExists
I'm pretty sure some changes either will have to be made to either one or both functions:
Function FileFolderExists
Function parse
I believe the parse function outpus an array, this I would like to pass to FileFolderExists function then have it search on the filter like:
Filter = arrayCodes()
' Filter = "array(1)|array(2)|array(3)|array(N+1)"
If Folder.Name Like Filter Then
'do this.
I hope all this makes sense.
Any Help is greatly appreciated.
Thanks,
BDB
Bookmarks