Hello everybody,

I need to open a csv file with semicolon separation but the separation
used is always the comma.

I tried this differents methods :

- Workbooks.OpenText Filename:="D:\Excel\data\file.csv",
Semicolon:=True, Comma:=False

- Workbooks.open Filename:="D:\Excel\data\file.csv", Format:=4

- Workbooks.open Filename:="D:\Excel\data\file.csv", Delimiter:=";"

- Workbooks.open Filename:="D:\Excel\data\file.csv", Delimiter:=";" ,
Format:=4

If I rename the file as a text file, it works !!!

If anyone has an idea, i want to properly develop and (if possible)
don't want to change the file type