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
Where the "THELATESTFILE" is the file i want to open as suggested above...![]()
Please Login or Register to view this content.
hope someone can help, thanks
Bookmarks