hey all, i have a macro which would import a text csv (ASCII) into excel, but the problem is the csv file contains foreign language characters, they would get translated to some funky symbol once they are imported. However, I tried to manually import the csv file (UNICODE), they would be imported correctly, can anyone explained to me why this is the case? Thank you so much!