excel vba read text file and extract numbers based on date

[Marc L]

As reading all files at each personal function call is a no sense way
(just need to read once ! Where is logic ?‼), better is to load all data
from all files in a specific worksheet and remove its duplicates …

So better before creating a thread is to well think of the global project,
avoiding wasting time - yours and ours ! - and a gas factory code
like in your duplicate thread on same subject !

And as Albert wrote :

If you can’t explain it simply, you don’t understand it well enough …

Albert Einstein
​

 

[mshome]

wise words thanks .