I'm having a problem, I need to open a file e.g "C:\1523002327_ADP_Tab_Din_II(R).xls" in a macro however I only know the last characters "ADP_Tab_Din_II(R).xls" at the start is a random 10 digit reference number which I have no way of predicting , is there any way I can open this file knowing only C:\ADP_Tab_Din_II(R).xls?

Any help would be very much appreciated!