Asterix
02-26-2008, 04:25 AM
With Application.FileSearch
.LookIn = "O:\NGMData7\Reserved\IT Library\Scheduling\Resource Allocations\Resource Allocations Spreadsheet"
.Filename = "Resource Allocations*.xls"
Application.StatusBar = "Please be patient..."
If .Execute > 0 Then
Hello all, assuming .Execute is greater than 0, how do I then extract the name of a/the file (i.e not the path) that I have successfully found (during the wildcard match)?
I could work out how to do this using a text extract formula but it seems long winded and I wondered if I'm just missing a property.
Thanks.
.LookIn = "O:\NGMData7\Reserved\IT Library\Scheduling\Resource Allocations\Resource Allocations Spreadsheet"
.Filename = "Resource Allocations*.xls"
Application.StatusBar = "Please be patient..."
If .Execute > 0 Then
Hello all, assuming .Execute is greater than 0, how do I then extract the name of a/the file (i.e not the path) that I have successfully found (during the wildcard match)?
I could work out how to do this using a text extract formula but it seems long winded and I wondered if I'm just missing a property.
Thanks.