View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Need help in VB6

Hi Anu

It sure does. Here is code (VB6 and VBA) to prompt fields 9 and 13 record by
record. Change filename to fit. I'm sure you can modify it from he

Sub Read()
Dim S As String
Dim SS() As String
Open "C:\Temp\Test.dat" For Input As #1
While Not EOF(1)
Line Input #1, S
SS = Split(S, vbTab)
MsgBox "Values are " & SS(9) & " and " & SS(13)
Wend
Close #1
End Sub

HTH. Best wishes Harald

"anu" skrev i melding
oups.com...

Hi,
When i open the data in notepad all the values are separated by tab.
does it help?

Thanks
Anu