The thing here is that the file ext changes from time to time from where i am getting the data so when i run this code i want the code to pick up any file with the file name without looking for file ext like xlsm or xls etc.
There changes ine to 4 ext like xlsm, xlsmb, xls, xlsx etc if this...