have one folder with a lot of "DAT file"-s
I need to pull in one worksheet values from cells A3 and A4 from all Dat file-s.
Hi Ivica,
We'll need to see some of these DAT files to understand how the data inside them is structured. Can you please supply some.
Do you want all data from the DAT files imported or just some parts?
Regards
Phil
It is "dat." files. I need just values from cell A3 and A4.
Column A
| ----- PRODUCTION START ----- |
| Putting: 31.05.2019 09:32:08 |
| Lot number: 12345678 |
| Material type: B59288R190B10 |
I am not familiar with your dat files structure which is why I need to see examples.
Even with the data you supplied above it's not clear what the next line is. Is it the beginning of another set of related data? Is it a blank line? Is it more data relating to the 3 preceding bits of data?
There's no point writing code that will break the first time you use it because it is not able to handle the structure of the file.
Regards
Phil
