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.
thanks in advanceWorkbooks.Open Filename:="X:\Support\BFNA\bfna_" & Format(Date, "DDMMYY") & ".xls"
Bookmarks