Filename changes daily, anyway to link to most recent file

[David]

All

I have a source file that changes names daily (date
included in name), is there anyway to look for the file
name but the pick up the lastest one created.

Either via vlookup or macro or Excel Query?

 

[Tom Ogilvy]

look at the filesearch object.

Then you can loop through the list returned and check the datetime to find
the latest. The filesearch object does have an option to sort by datetime,
but I have heard it isn't reliable.

see excel vba help on FileDataTime