utf-8

Hi all, a friend of mine created a marco that converts the excel entries into a tab delimited .txt file. Unfortunatley since (i guess) an update, it will always save as ANSI, which causes some e.g. kyrillic symbols to be displayed as ? instead of the actual symbols shown in the excel file...

Hello, I have a .csv file with data that contains spanish characters (á, é, ñ...). If opened in Notepad++ I can see the characters correctly, but when I open it in Excel I get the typical strange characters (Fern~ºndez, instead of Fernández). I need to open several of this files using VBA and...

Hello, I am beyond frustrated as I can not figure out a way import utf 8 file to excel using vba. I tried macro recorder and the code is very complex which is beyond my understanding as I am a beginner. I want to use file picker to open the csv. Any help would be greatly appreciated. Thanks

I have a project in which I need to save file as utf - 8 and I am having 2 issues: 1) I can not figure out a code to save the file as UTF 8 2) and when I manually save it as UTF 8 and when I open that file in excel, it shows the same text in same format and not in converted version. The file...

Hi, I am trying to insert an rss feed from the web into Excel, but this seems to have stopped working ever since May 2019. The link I am trying to insert is: https://www.totaljobs.com/JobSearch/RSS.aspx?Keywords=Performing-arts&LTxt=Birmingham&Radius=10 The data appears correct when you...

Hello, I am trying to create vba code that can export to csv with UTF-8 file format, with few little function <tbody> # Use A B 1 false Apple Bat 2 true Airplane Boss </tbody> when it export it only export true such as <tbody> # A B 1 Airplane Boss </tbody> with all the...

Hello, Do you have any ideas how can I open txt/csv file with encoding UTF-8 or ANSI and save it wit unicode encoding?

Hi! i Need to save my file with filter setting Character set to UTF-8 and Field Delimiter to ; (semicolon). Is it possible, here's what I only have so far :/ Sub save() Dim fName As Variant fName = Application.GetSaveAsFilename(InitialFileName:="", FileFilter:="Excel Files (*.csv), *.csv"...

I have to import several HTTP webpage's source codes into separate Excel worksheets. I found this great code by searching the forum, which does exactly what I need: Sub ImportHTMLSource() Dim FileName As String Dim FileNum As Long Dim Sh As Worksheet FileName = "D:\Source.txt" FileNum =...

Dears, I'm struggling to find a way to save an excel file like a ".txt UTF-8". I used to simply save my file like a .csv (comma delimited), but now I have to deal with Chinese characters and I learnt from internet that chinese/japanese/korean characters have some kind of issues and aren't...

Hello, I'm using code to generate individual CSV files for each worksheet of a single workbook. However, these individual CSV files that are generated need to be within UTF-8 format. Could someone assist me with modifying this code for those purposes? I greatly appreciate it! Thanks! Sub...

I am using the following vba code to import all txt files in the active directory into excel. Sub ImportTXTfiles() Dim Path As String Path = Application.ActiveWorkbook.Path & "\" Filename = Dir(Path & "*.txt") Do While Filename <> "" Workbooks.Open Filename:=Path & Filename, ReadOnly:=True For...

Hi I need to export selected cells as an UTF-8 format compatible file. I am ok if it were just a test file - but have no idea how to ensure it is UTF-8 compatible. Any leads/pointers or assistance appreciated. I am happy to post once the solution once I have it working Cheers

Hi there! Have been using this macro to export as a CSV. I need it modified to export in UTF-8 Can someone with more VB skills than me help please :-) Public Sub ExportToTextFile(FName As String, _ Sep As String, SelectionOnly As Boolean) Dim WholeLine As String Dim FNum As Integer...

I have this csv file which is UTF-8 encoded. It contains special characters like ë, ï, etc. To import it into Excel, I use the following code, where Origin:=65001 should ensure that Excel reads it as an UTF-8 encoded file: Workbooks.OpenText Comma:=True, DataType:=xlDelimited...

<TABLE sizset="14" sizcache="6"><TBODY sizset="14" sizcache="6"><TR sizset="14" sizcache="6"><TD class=votecell> </TD><TD class=postcell sizset="14" sizcache="6">I use the code as below. Private Sub CommandButton1_Click() Const File$ = "C:\CsvfileTest2.csv" Dim Fso, MyFile Set Fso =...