Extract Values from external Files

Hi Jbeau,,

after figuring out what went wrong, why the file got corrupted etc.. my stupidness... i forgot to edit sheet file name and xls instead xlsx



i finally fixed it .. your code works for my purpose just perfectly.. i need to try to add possibilities where the reference formulas didnt get add

yes most files are 6 digit.. but there are also files with same duplicate names.. which is called then for example 100000 - A.xls, for second duplicate 100000 - B.xls
on my sheet there is also a helper column .. which has only alphabets..

like this

100000 A = Filename 100000.xls
100001 A = Filename 100001 - A.xls
100001 B = Filename 100001 - B.xls

although those duplikates are not much, but it would be supergreat if that can be also added and fixed..

neverthless thank you for your code.. it saved alot of my time.. the rest i can edit manually ;-))



add possibilities like