Export from Excel to Text file in UTF16 encoded

[xcelgeek]

Hi,

I am able to export the data from "Temporary Products" to text file called "Product Master.txt". I want to get this text file in UTF16 encoded format. Please help me.

I have assigned code to a button called "Prepare to Upload" button "Temporary Products" tab.

You can see the exported data has some question marks (???), as this is the foreign language in the "Temporary Tab". If I make it UTF16 encoded, it will be shown properly in text.

Here is the file -


https://skydrive.live.com/redir?resid=CF0E71ECBE7252C!108&authkey=!ACzI4Hn0E1uOrzQ

Regards,
Lucky

 

[thonggraphicdesign]

Thanks for letting us know it works.
Cheers!

Dear ZVI.

I have problem with my code. I need to export to txt from VBA code in Excel that keep special characters and not add double quotes in the sentence contain comma. If export with Unicode (UTF-16) then it's okay. But due i used excel version2010, it isn't support to export to Unicode (UTF-16) because maximum only UTF-8). Pls help check and advise how to fixed below code? (You can see my data after export used Unicode (UTF-8) formated). Sincerely thanks.




Here is my code (If export with this code then only export UTF-8 fomat and still contain double quotes) :

ActiveWorkbook.SaveAs Filename:="D:\NHAP DON HANG\THERMAL\ORDER THERMAL\NIKE-" & "IM#1012" & "-" & Me.Maker.Value & "-" & Me.FTY.Value & "-" & Me.STY1.Value & "-" & Sheets("item").Range("CZ2").Value & ".txt", _
FileFormat:=xlUnicodeText, CreateBackup:=False


Here is my data after export (I need my data not contain double quotes at the sentences contain comma):



90 N BA5245 021 082015 EKP MADE IN VIETNAM / FABRIQUE AU VIETNAM / HECHO EN VIETNAM / FABRICADO NO VIETNAME / СДЕЛАНО ВО ВЬЕТНАМЕ / SZÁRMAZÁSI ORSZÁG: VIETNAM / ZEMLJA PROIZVODNJE: VIJETNAM / DRŽAVA PROIZVODNJE: VIETNAM / ПРОИЗВЕДЕНО ВЪВ ВИЕТНАМ / FABRICAT ÎN VIETNAM / RAŽOTS: VJETNAMĀ / ITHAL/YABANCI VİYETNAM 'DA YAPILMIŞTIR / 001 "BODY, CORPS, CUERPO, CORPO, OBERSTOFF," "BOVENSTOF, ΕΠΑΝΩ ΜΕΡΟΣ, KROP," "ÖVERKROPP, RUNKO, BOL, КОРСАЖ, TĚLNÍ" "ČÁST ODĚVU, TUŁÓW, TÖRZS, GORNJI DIO" "ODJEVNOG PREDMETA, TELOVÁ ČASŤ ODEVU," "GORNJI DEL OBLAČILA, ОСНОВНА ЧАСТ, CORP," "GLAVNI DEO, PAGRINDINĖ PRIEKINĖS PUSĖS" "DALIS, PIHAOSA, GALVENĀ DAĻA," "GÖVDE KISMI," :الجسم 51% "POLYESTER, POLIÉSTER, POLIESTERE," "ΠΟΛΥΕΣΤΕΡΑΣ, POLYESTERI, ПОЛИЭФИР," "POLIESTER, POLIÉSZTER, ПОЛИЕСТЕР," "POLIESTERIS, POLÜESTER, POLIESTERS," بولياستر 49% "NYLON, NAILON, NYLON (PERLON), ΝΑΪΛΟΝ," "НЕЙЛОН, POLIAMID ILI NAJLON, NAJLON," "НАЙЛОН, NAILONAS, NEILONS, NAYLON," نايلون "LINING, DOUBLURE, FORRO, FODERA," "FUTTERSTOFF, VOERING, ΕΣΩΤΕΡΙΚΗ" "ΕΠΕΝΔΥΣΗ, FOR, FODER, VUORI, FÔR," "ПОДКЛАДКА, PODŠÍVKA, PODSZEWKA, BÉLÉS," "PODSTAVA, PODLOGA, ПОДПЛАТА, CĂPTUŞEALĂ," "POSTAVA, PAMUŠALAS, VOODER, ODERE," "ASTAR," :بطانة 100% "POLYESTER, POLIÉSTER, POLIESTERE," "ΠΟΛΥΕΣΤΕΡΑΣ, POLYESTERI, ПОЛИЭФИР," "POLIESTER, POLIÉSZTER, ПОЛИЕСТЕР," "POLIESTERIS, POLÜESTER, POLIESTERS," بولياستر