OpenText , Column separation problem

[martjn]

I have made an VBA project for opening trends-files from an Operatorterminal
The format of it is .skv

I have made this

Dim Filelogg As String
Filelogg = Application.GetOpenFilename("Trends (*.skv), *.skv, Text (*.txt), *.txt", 1, "Open Trendfile")

Workbooks.OpenText Filename:=Filelogg, _
        StartRow:=1, DataType:=xlDelimited, _
        ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True _
        , Comma:=False, Space:=False, Other:=False

The trendfile are separates the columns with a semicolon. Ok now this should work ?
But nah it doesnt, it separates with an comma!? Comma:=False Semicolon:=True Uhm i dont understand this.

But when i have renamed the Trendfile from *.skv into *.txt it works perfectly.
I have defined it to parse the text as it should. but it doesnt. but it does with an renamed trend to .txt

I cant imagine whats wrong.
Can you?

Thanks in advance.
Regards, Martin

 

[martjn]

Doesnt anyone of you have any clue at all?

By the way.. Im using Excel 2003. And have tried it in 2000 and xp.
same result on all three .

 

[martjn]

bump.

 

[martjn]

Is it only me that experience this problem?

Have anyone of you tested the code and it works for you?

Date;Time;Sum Massflow;Sum Fraction;Massflow l/min; Fractionflow l/min;PH;Cond; Turb;Temp C

20060613; 10:23:16;0,00;0,00;0;0,00;7,24;125;1,74;12,65
20060613; 10:23:26;2,90;0,00;29;24,10;7,24;125;1,74;12,70
20060613; 10:23:36;13,70;0,00;84;18,07;7,24;125;1,74;12,80
20060613; 10:23:46;28,40;0,00;86;1,20;7,25;125;1,77;9,80
20060613; 10:23:56;42,40;0,00;85;2,41;7,25;125;1,74;9,20
20060613; 10:24:06;56,30;0,00;85;1,20;7,25;125;1,71;8,95
20060613; 10:24:16;69,90;0,00;85;0,00;7,24;125;1,71;8,80

 

[martjn]

The code in previous post was an example of the *.skv trendfile.

Named to .txt it work
named to .skv (orginal) it wont work.