Chip Pearson has written code to allow you to open a CSV file and specify
the delimiter:

http://www.cpearson.com/excel/imptext.htm import/export text files

--
Regards,
Tom Ogilvy

"Yann59" wrote in message
om...
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