[RESOLVED] - how to import a csv file into Excel with VBA only

[ZeBula]

so far i got this part...

can anyone help me out here?



Set oExcel = New Excel.Application

oExcel.Workbooks.Add
oExcel.Sheets.Add
oExcel.Visible = True




' thanks to another post i found this and it works fine.

With oExcel
.WindowState = xlMinimized
' .Visible = False
'hide excel alerts msgboxes
.DisplayAlerts = False
.Workbooks.OpenText FileName:="c:\sampleCSV.txt", _
Origin:=xlWindows, _
StartRow:=1, _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, _
Tab:=False, _
Semicolon:=False, _
Comma:=True, _
Space:=False, _
Other:=False
End With