Closed

What is the proper procedure for importing Unicode characters into an array using VBA? The raw txt file I'm trying to import shows the unicode characters properly, but when I read the file using the "Line Input #1, String1", all unicode characters change

What is the proper procedure for importing Unicode characters into an array using VBA? The raw txt file I'm trying to import shows the unicode characters properly, but when I read the file using the "Line Input #1, String1", all unicode characters change to this "Ó". Any ideas?

Skills: Excel, Mac OS, Visual Basic

See more: line input unicode, unicode vba, what is vba, excel 2013 vba, what, raw file, proper, c+×, trying, import excel array, excel array, txt file import excel, excel import txt, excel vba array, ???, vba read txt, vba read excel file, excel read txt, vba excel procedure, read excel visual, import visual basic, basic characters, vba procedure, shows excel, importing

About the Employer:
( 5 reviews ) Stockholm, Sweden

Project ID: #5124188

6 freelancers are bidding on average $27/hour for this job

finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I have also worked on advanced VB features li More

$50 USD / hour
(65 Reviews)
5.5
zExcel

Could you send me the text file so I can have a look and will get back to you asap ----------------------------------------------------------------------------------------------------------------------

$33 USD / hour
(16 Reviews)
4.5
adim

It can be done using fso. I have a working sample of workbook who opens an unicode file, put it in a byte array and then save the array as another unicode file.

$16 USD / hour
(13 Reviews)
4.3
amelnyk

Hello, I know how to read file and interpret text in unicode and utf-8 in VBA. Why do you need array for that purpose? In most cases string type is enough. Could you please specify more details about project? More

$22 USD / hour
(11 Reviews)
3.8
sg11513

Hi, Greetings! We have experienced in VB, for reference you can visit our website www.bspartners.in to check our work experiences and reviews. we can discuss more details over PM to share the same understanding over More

$16 USD / hour
(5 Reviews)
3.6
italosanchez

Hello, we are a team who specializes in task automation tools, web scraping and new technologies. For your problem, you have to read it from the file in binary mode (not with Line Input), and then convert it from UTF-8 More

$22 USD / hour
(0 Reviews)
0.0