| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving Excel 2010 files as web page or single file web page | Excel Discussion (Misc queries) | |||
| Excel 2010 not opening in maximized view | Excel Discussion (Misc queries) | |||
| how to import a text file in excel 2010 | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Linear Mode
