Read File Based on Date VBA

[sitzalke]

Hi. I need to read a file, based on latest date. Using VBA. I really don't know how to do since before this I only put exact name of the filename.

I know how to do it using vb.net, I do like this,

 Dim stamp As String =
              DateTime.Now.ToString("yyyyMMdd", CultureInfo.InvariantCulture)


        Dim TEXTfylname As String = "MB52_" & stamp & ".xlsx"
        Dim txtfile As String = localPath & TEXTfylname

I really need to know how to read it using vba.

Thanks all.

Ps: I am beginner to macro.

 

[Yongle]

You may be able to get the string you require using VBA function FILEDATETIME

this link shows you what the function returns etc
https://www.techonthenet.com/excel/formulas/filedatetime.php

 

[Yongle]

Reading OP again. I think this is what you want

Sub DateStamp()
    Dim stamp   As String, TEXTfylname As String, txtfile As String
    
    stamp = Format(Now, "yyyymmdd")
    TEXTfylname = "MB52_" & stamp & ".xlsx"
    txtfile = CurDir() & "\" & TEXTfylname             [COLOR=#006400] 'possibly[/COLOR]
Debug.Print txtfile
    txtfile = ActiveWorkbook.Path & "\" & TEXTfylname   [COLOR=#006400]'or maybe this[/COLOR]
Debug.Print txtfile

End Sub