I have multiples txt files and I would like create VBA to transform txt in tables.
Example:
file_01.txt
|000|12162020|XXXXXX|
|001|421,34|0,50|210,67|
|001|523,45|0,50|261,725|
|005||
file_02.txt
|000|11162020|XXXXXX|
|001|400,00|0,50|200,00|
|001|100,00|0,50|50,00|
|005||...