Link or Open file by date modified

If there is only ONE of these dated files each day, then this would find and open that one file:

Option Explicit

Sub OpenDatedCSV2()
Dim wbName As String, fPath As String

fPath = "C:\2009\"      'remember the last \ in this string
wbName = Dir("DailyReportSales." & Format(Date, "YYYYMMDD") & "*.csv")

If wbName <> "" Then Workbooks.Open fPath & wbName

End Sub

Does this get you started?

JBeaucaire,

What if the they need the most recent file, which may not be current date.

I am referring to this line from your latest post:

wbName = Dir("DailyReportSales." & Format(Date, "YYYYMMDD") & "*.csv")

For instance, what if they need to run this early in the morning and the latest file is prior day? Or 3 days prior after a weekend, etc.

Thats the particular problem I am having. I'll begin a new thread to discuss because it might be different from this topic.