Importing most recent file
 

I need to import data (txt file) that changes often. Each time it changes
the name changes based on the time stamp. How can I import the most recent
filewith macro or VBA?

Importing most recent file
 

You will have to set up a filesystemobject to get the createdate from
the files in the specified directory.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546110

Importing most recent file
 

You can try something like this:

Dim dt as Date, dtMax as Date
Dim sPath as String, sName as String
Dim sMax as String, bk as Workbook
sPath = "C:\MyFiles\" '<= change to your directory
sName = dir(sPath & "*.txt")
dtMax = 0
sMax = ""
do while sName < ""
dt = fileDateTime(sPath & sName)
if dt dtMax then
sMax = sName
dtMax = dt
end if
Loop
set bk = Workbooks.Open(sPath & sMax)

--
Regards,
Tom Ogilvy


"wrcaz" wrote in message
...
I need to import data (txt file) that changes often. Each time it changes
the name changes based on the time stamp. How can I import the most
recent
filewith macro or VBA?