Oct 23 2017 02:52 AM
Oct 23 2017 02:52 AM
Hi,
I am furious that this has to be so difficult.
I am using Office 2016 x64 on Windows 7
I have CSV files that can potentially have multiple language characters in them. They are encoded in UTF-8 and separated by commas.
I want to be able to double click on them to open them nicely and start working (like OpenOffice.org does).
Description
Sub Open_CSV_UTF_8() filetoopen = Application.GetOpenFilename("Text Files (*.txt;*.csv), *.txt;*.csv") If filetoopen = Null Or filetoopen = Empty Then Exit Sub Workbooks.OpenText Filename:=filetoopen, _ Origin:=65001, DataType:=xlDelimited, Comma:=True End SubWhen I click my custom button, a dialog box appears to select the CSV file I want to open. I select it and voila it gets opened (alas, to a new file, insted of imported to the current blank workbook) but the characters are still scrambled. Obviously Workbooks.OpenText does not work.
Questions
Thanks a bunch!!
Oct 23 2017 04:41 AM
Oct 23 2017 06:11 AM
Hey Jan
Thank you, but I will not be using one single file for importing but disposable files each time. :S
Thanks!
Oct 23 2017 06:35 AM