Hi. I am trying to do a VBA script that automatically selects today date file in a destination folder and uses this in an array formula.
When typing in the formula in the sheet without VBA this works. (Ctrl + Shift + Enter)
=IFERROR(INDEX('[Deliveries - 13.07.2018.xls]Deliveries -...