Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default OpenText, column separation problem.

Hello!

I have an strange problem with my VBA-Addin.
I have made an toolbar with an openfile button.

Code looks like 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

..
Now this should work to separate the columns with an Semicolon (;)

The files i use for this is in format .skv but when i use this function it
separates the columns when a comma (,) appear.
I cant figure this out.. Comma:=False, Semicolon:=True

But when the file extension is changed from .skv to .txt it works fine.

Example on the .skv file.

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

Thanks in advance for any tip that might help me forward.

Regards,
Martin
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column that needs separation Aaron Excel Discussion (Misc queries) 2 May 20th 10 02:05 AM
Imported text separation problem Dave Excel Discussion (Misc queries) 2 January 14th 08 09:19 PM
Problem with 'Workbooks.OpenText jo Excel Programming 0 August 30th 06 06:38 AM
Workbooks.OpenText problem in XL2000 Mike Iacovou Excel Programming 4 May 18th 06 06:07 PM
After OpenText all pastes from external apps use format from OpenText Jim[_31_] Excel Programming 1 November 8th 03 02:17 AM


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"