how to reference/open last file modified

[muyBN]

In the following code, I want to search for and open the most recent file
modified, but don't know how to write that particular line. Assistance will
be appreciated. Thanks.

strPath = [path name]
strFirstFile = ActiveDocument.name
With Selection
With Application.FileSearch
.NewSearch
.LookIn = strPath
.SearchSubFolders = False
.FileName = "*.csv"
.Execute (msoSortByLastModified)
intFiles = .FoundFiles.count
If .Execute(msoSortByLastModified, msoSortOrderAscending) > 0 Then
strFile = [last modifed file]
End If
End With
End With
Documents.Open (strPath & "\" & strFile), AddToRecentFiles:=True,
Format:=11

 

[Perry]

Look at yr previous posting in this group.
--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

 

[muyBN]

Sorry, it was late and I thought I had accidentally closed the first question
(since there's a lag in questions actually being posted).

--
Bryan

Look at yr previous posting in this group.
--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

In the following code, I want to search for and open the most recent file
modified, but don't know how to write that particular line. Assistance
will
be appreciated. Thanks.

strPath = [path name]
strFirstFile = ActiveDocument.name
With Selection
With Application.FileSearch
.NewSearch
.LookIn = strPath
.SearchSubFolders = False
.FileName = "*.csv"
.Execute (msoSortByLastModified)
intFiles = .FoundFiles.count
If .Execute(msoSortByLastModified, msoSortOrderAscending) > 0
Then
strFile = [last modifed file]
End If
End With
End With
Documents.Open (strPath & "\" & strFile), AddToRecentFiles:=True,
Format:=11