Hi,

I have some code which looks to open a workbook which is saved daily as Daily - Sales DDMMMYY.xlsx. I currently have the below code: 

Please Login or Register  to view this content.

But instead of looking at the previous day, I need it to look at the previous business day i.e. if today is monday, I want to look at friday's spreadsheet as none are created on weekends. Does anyone know how I can do this?

Thanks!