I tried to create a program which reads a list of files on a folder and runs the loop for each of the files (basically excel A into result A, B into result B, and so on). The program runs fine when there is only one file in the folder. But when I added two files (A and B) into the folder, the program only returns with one result only. What made it weirder is that the result is named as result A but the content is B.
From what I observed, the program runs smoothly, but when it gets to run the second file, it just overwrites the result into result A with its own content. How do I make it properly so that file A will be saved as result A, file B into result B, and so on?