Open a CSV file with custom delimiter

Question

I have a MAIN.xlsm with a macro called "open_input_workbook" which opens a CSV file.

The problem is that when I open the file using that macro, the file doesn't respect the columns, I'll show you with some screenshots:

input.csv open doing Double-Click on it:

input.csv open with the macro:

Macro Code:

Sub Open_input_Workbook()
  Workbooks.Open "C:\input.csv"
End Sub

Any help is welcome.

Thank you for your time

You need to set the delimiter to ; the default is , on a csv. — Warcupine
– Warcupine, Commented Jun 5, 2020 at 12:12
Tried with the next code: Workbooks.Open "C:_Disco_local_Proyectos\AppMacroExcel\input.csv", Delimiter = ";" but still doing the same @Warcupine — javiertxu18
– javiertxu18, Commented Jun 5, 2020 at 12:19
You might need to save it as a .txt then reopen it with openworkbooks. You can try to use format = 4 but I think the formatting of the csv is already messed up. — Warcupine
– Warcupine, Commented Jun 5, 2020 at 12:26

Mark7000 · Accepted Answer · 2020-06-05 13:30:11Z

1

try to use Workbooks.OpenText instead of the open command. That will allow you to set the delimiter.

answered Jun 5, 2020 at 13:30

Mark7000

564 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1