Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CSV separator in macro?
I've changed the list separator to semicolon. Now I try to open csv file
(delimited by semicolons) from macro with command: Workbooks.Open FileName:="filename.csv", but it doesn't work. The entire row open to first cell. how can I tell in open command the separator is semicolon? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use 100 separator inspite of 1000 separator in excel | Excel Worksheet Functions | |||
Separator | Excel Discussion (Misc queries) | |||
list separator | Excel Discussion (Misc queries) | |||
hundreds separator | Excel Discussion (Misc queries) | |||
Decimal separator | Excel Programming |