Find newest file in a folder

[duckboy1981]

Hi all,

I am doing a project for work at the moment where by I have to manipulate a report compiled by an external program and do various bits and bobs to it. Trouble is, the other program creates a new version every time it runs the report (i.e filename.1.xls, and the next day filename.2.xls, and so on). Is there any way of searching the folder these files are in to find the newest file and select that one as the one to open and manipulate? There will be no files other than these in the folder.

Thanks,
David

[royUK]

Does this help

http://j-walk.com/SS/excel/tips/tip97.htm

[duckboy1981]

Looks to be just what I am after. I will have a play when I get chance and let you know.

Thanks

[royUK]

Thanks, let us know & mark the Thread solved when you have checked.

[MickG]

Hi, This is more or less what you've already got from "RoyUk"
NB:- Change File Path to suit.

Please Login or Register  to view this content.

Regards Mick

[duckboy1981]

Thanks very much, works a treat!