Vlookup to closed spreadsheet where date suffix changes each day

[Shales]

Hi,

I was wondering if somebody could help me work out how to do a formula to lookup data within a closed spreadsheet where the date of the file changes each day with the suffix of todays date. I have been searching and trying to do this myself with the below formula but I don't seem to be getting anywhere with it.

VLOOKUP(A1,INDIRECT("[Z:\Example\Company "&TEXT(TODAY(),"yyyy-mm-dd")&".csv]Sheet1!F:L"),7,0)

The spreadsheet must remain closed for protection purposes.

Any help would be greatly appreciated.

Thanks

 

[etaf]

indirect will not work on a closed workbook
at one time indirect.ext used to work - not used for years


http://www.ashishmathur.com/tag/indirect-ext/

https://www.mrexcel.com/forum/excel-questions/86381-indirect-ext-morefunc-xll-addin.html