IF statement in VBA code

[JonnnyExcel]

I am thinking an IF statement is what I will need but maybe not.

I have VBA code that finds the previous day's file and copies information into today's file. There are occasions when the previous day’s file doesn’t get generated, ie. no data, operator forgot to create file, etc. I need my macro to look for the previous day’s file and if it doesn’t find that file then look for the file from 2 days ago and so on.

I am already using the workday function so weekends and holidays are already figured in.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Thank you in advance.

 

[bensonsearch]

HI,
can you paste a sample of your code please?

 

[AlphaFrog]

I don't know what file naming convention you are using but here's an example of looking for a file name that has a date in the name e.g. "File ddmmyyyy.xls"

It finds the most recent dated file name.

    Dim MyFolder As String, MyFile As String
    Dim counter As Long

    MyFolder = "C:\Temp\"

    Do
        MyFile = Dir(MyFolder & "File " & Format(Date - counter, "ddmmyyyy") & ".xls")
        counter = counter + 1
    Loop Until MyFile <> "" Or counter = 100
    
    If MyFile <> "" Then
        MsgBox MyFile, vbInformation, "Most Recent File"
    Else
        MsgBox "No file found."
    End If

 

[JonnnyExcel]

Thank you for the response. Sorry for not replying sooner as I got side tracked on another task.

This works and I have revised the file naming to match my format.