Hi,

An application saves a text file in a local folder with a specific textfile name
The text in the textfiles are exactly the same, they just vary in figures.

e.g. of textfile names in the folder & timestamps
RS00A1012009 17/02/2009 5:50PM
RS00B1012009 17/02/2009 7:09PM
RS00C1012009 17/02/2009 7:15PM
RS00A1001009 18/02/2009 5:00AM
RS00B1001009 18/02/2009 6:00AM

Now what i would like a macro to do is import the "latest text file" from the above list which has the text "A" in it... so therefore the textfile i would like to open in the above instance is:
RS00A1001009 18/02/2009 5:00AM

I would therefore then like it to be opened in the following code fashion
    Workbooks.OpenText Filename:= _
        "C:\Documents and Settings\L487698\Desktop\THELATESTFILE.txt", Origin:=-535, _
        StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 1), Array(19 _
        , 1), Array(29, 1)), TrailingMinusNumbers:=True
Where the "THELATESTFILE" is the file i want to open as suggested above...

hope someone can help, thanks