not sure what you're looking for, but there is a recentfile object
Application.RecentFiles(2).Open
where the number is the index of the recent file list


--


Gary


"jaden41" wrote in
message ...

Hey folks,

Im trying to get vlookup to gather data from the most recently added
file in a folder but so far have come up empty handed. I've tried
embedding the today and text functions in the vlookup code and am not
remotly skilled in VBA.

Is there any method that you folks are aware of, is there a udf out
there or any other tricks that may work?

Thanks so much in advance :)


--
jaden41
------------------------------------------------------------------------
jaden41's Profile:
http://www.excelforum.com/member.php...o&userid=28015
View this thread: http://www.excelforum.com/showthread...hreadid=475214