opening CSV file in Excel 2010 from VBA
 

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

opening CSV file in Excel 2010 from VBA
 

On Oct 25, 8:01*am, Sonnich Jensen wrote:
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

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