Macro to open file name in date format

Hi Friends,

I want my macro to open a file from a folder whose name is bfna_210710 (Name contains yesterday's date). I know the simple code which open the file with today's date. Could you fine tune the below code so that it opens the file with yesterday's date included in the file name.

Workbooks.Open Filename:="X:\Support\BFNA\bfna_" & Format(Date, "DDMMYY") & ".xls"

thanks in advance