Macro to open file with Current date
===

I am using a macro to open a file that the file name will change each day because of the current date.

File\today_20120723 for today.

I am trying this but it isn't working. Suggestions

    Dim OpenPath As String
    Dim OpenName As String
    
    OpenPath = "N:\File\": OpenName = OpenPath & "today_" VBA.Format   (Date, "YYYYMMDD") & ".xlsx"
    
   
    
    Workbooks.Open Filename:=OpenPath

Thanks for the help

