[David]

I wish to call Emeditor command line in Excel VBA. Now I encountered a problem and wish to get your help. Thanks in advance.

I have a CSV file which is saved by Excel.
1) The seperator for the data is Tab-seperator;
2) Its encoding is UTF-16LE with BOM.

I want to replace Tab-seperator with ; and then save the file as UTF-8 with BOM.

I try this command line under CMD status. No error appear but nothing happen.May I trouble you help me? I don’t know how to upload file in this forum!

E:ToolEmEditorEmEditor.exe d:BOM.csv /fc t /rw ; /cp 65537 /cps 65001 /ss+ /sa d:BOM2.csv :-(

[Yutaka Emura]

Hello David,

The command line is not for this kind of task. Please use EmEditor user interface, or an EmEditor macro to do this task. You can call an EmEditor macro from a command line, too.

Thanks!

[David]

Hello,Yutaka – san,

Thank you very much!

[Author]

Posts