Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i delete a file from recent documents file in excel | New Users to Excel | |||
Most recent file list | Excel Programming | |||
Most Recent File problem - Help!! | Excel Discussion (Misc queries) | |||
~Recent File~ | Excel Worksheet Functions | |||
Locate Most Recent File | Excel Programming |