File name according to cell value

[HaroonSid]

hi,
i want to give file name as cell value

for example
range("ad1").value = 11.11.19

then
the formula

Please Login or Register  to view this content.

if range("Ad1").value = 12.11.19
then the formula should be

Please Login or Register  to view this content.

hope some one will help

[davesexcel]

Check out "indirect" to reference a different workbook