I tried it and it works fine...
vb Code:
Private Sub CommandButton1_Click() Set exlApp = New Excel.Application exlApp.Visible = True exlApp.Workbooks.OpenText Filename:="p:\Sid.CSV", _ Origin:=xlMSDOS, StartRow:=1, DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, _ Tab:=True, Semicolon:=False, Comma:=False, Space:=False, _ Other:=False, FieldInfo:=Array(1, 1), TrailingMinusNumbers:=True MsgBox (exlApp.Cells(2, 1)) End Sub
Can you upload your csv file?




Reply With Quote