File Name Retrieval

[fireblade]

Hi,

I need some help on retrieving file names in a specific location, the only problem is the filename is relevant to the machine I am connecting to, so need some sort of wild card option to search for the constant in the file name, and then pull back the full name.

As an example, if I have a number of machines names computer001 through to computer100, and each machine has a file named computername_status.log (eg computer089_status.log) how can I look for the _status.log part of the filename and then return the complete name to my script?

It's not a simple as getting the computername as this is an example, the file I'm after is a filename followed by a random 3 figure number.log hence the wild care requirement.

I hope this is clear in what I am trying to do...

Thanks.

[westconn1]

myfile = Dir(path & "*._status.log")

will return the first file in the path that matches, calling Dir after (ususally in a loop) will get the next etc.

[fireblade]

So simple it's genius, thanks...

Resolved