Part of mask from cell ref

Hi Guys

can you advise how I can amend the below code to pick up the date from cell A1 rather than Today -3. Date will be in format YYYYMMDD

thanks

Noel

Please Login or Register  to view this content.

Full code attached- am trying to avoid the situation where I need a different macro for Mondays and weekdays as the file picked up is received T-1

thanks

Noel

Please Login or Register  to view this content.

bump- thanks