1. T

    Open .csv files and show Spanish characters UTF-8 using VBA

    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...
  2. A

    Importing utf-8 coded csv to excel using VBa

    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
  3. A

    Vba to save and open excel file as UTF - 8

    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...
  4. F

    Importing RSS Feeds into Excel (XML V1.0 and UTF-8)

    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...
  5. A

    Trying To Create Export to CSV with UTF-8 with few function

    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...
  6. T

    Macro to open txt file and save again with different encoding

    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?
  7. S

    Save as UTF-8

    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"...
  8. T

    import UTF-8 HTML complete source codes of a HTTP webpage via vba

    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 =...
  9. M

    VBA Macro to save Excel file like ".txt UTF-8"

    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...
  10. M

    Export CSV into UTF-8 Format

    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...
  11. T

    Import text file as UTF-8

    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...
  12. D

    UTF-8 Format

    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
  13. J

    CSV export macro in UTF-8

    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...
  14. K

    Workbooks.OpenText doesn't work with UTF-8, ActiveSheet.QueryTables.Add does?!

    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...
  15. D

    use vba creat csv but the format of csv is not correct.

    <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 =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back