opening CSV file in Excel 2010 from VBA

  • Thread starter Thread starter Sonnich Jensen
  • Start date Start date
S

Sonnich Jensen

Hi

This should work

Workbooks.Open Filename, Format:=4, Delimiter:=";"

but it opens so, that all my semicolon separated text is on on coloumn
- what do I do wrong?

Sonnich
 
Hi

This should work

    Workbooks.Open Filename, Format:=4, Delimiter:=";"

but it opens so, that all my semicolon separated text is on on coloumn
- what do I do wrong?

Sonnich
Click to expand...

I tried your code using Excel 2007 and it worked perfectly:

Sub Sonnich()
Dim Filename As String
Filename = "C:\TestFolder\test.txt"
Workbooks.Open Filename, Format:=4, Delimiter:=";"
End Sub
 
Back
Top