I have made an VBA project for opening trends-files from an Operatorterminal
The format of it is .skv
I have made this
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
The format of it is .skv
I have made this
Code:
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
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