Hi there,

I have a very disturbing problem.

I need to import CSV file into Excel. The file is generated dynamically and I have no possibility to change the way it's done.

When I import the data into my Excel SpreadSheet either by opening it as CSV or by using QueryTables some specific for my language letters are substituted by "?". the CSV file itself also contens that letter insted of the proper ones.

Could You suggest any way I can change the encoding via VBA while importing the file ?

Thank You for any suggestion