Hi,
See
VB "FileDateTime" function which will give you the info to find latest
modified date ...
Example from
VB Help:
Dim MyStamp
' Assume TESTFILE was last modified on February 12, 1993 at 4:35:47 PM.
' Assume English/U.S. locale settings.
MyStamp = FileDateTime("TESTFILE") ' Returns "2/12/93 4:35:47 PM".
"Michael Smith" wrote:
I have a file "C:/temp"
I have files in this folder with only 1 worksheet in each workbook.
There are many file in this folder, however I want my sub to take the
last 2 files to have been saved to this folder and copy them to be 2
worksheets in a separate workbook.
Possible? TIA - Mike
*** Sent via Developersdex http://www.developersdex.com ***