I want to loop through excel files in a folder and extract information. My problem is that the file names of my excel files are in Vietnamese, so when I use the Dir function to loop, it does not work. How can I loop through files in a folder and open them without specifically referring the names. I want to loop through excel files in a folder