Extracting unicode text from Excel spreadsheet using VBA

Question

We generate HTML from text in an Excel spreadsheet. The text contains unicode representations of international characters. When we use VBA to extract the text and output it to a file, it is written as ANSI (ASCII). Is there a way to preserve the unicode representation using VBA?

Bruce

VBA uses Unicode internally, so there shouldn't be any problem doing this in theory... can you insert a bit of the code you're using please? Especially the bit where you're writing the file. — Ant
– Ant, Commented Jan 25, 2010 at 16:08

Community · Accepted Answer · 2017-05-23 10:27:36Z

3

The default file writing mechanisms in VBA are ANSI (just like VB6).

You need to use a different method. One way is to use the FileSystemObject.

   Dim fso As Object, MyFile As Object
   Set fso = CreateObject("Scripting.FileSystemObject")
   Set MyFile = fso.CreateTextFile("c:\testfile.txt", False,True) 'Unicode=True'
   MyFile.WriteLine("This is a test.")
   MyFile.Close

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered Jan 27, 2010 at 11:25

MarkJ

30.4k6 gold badges72 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Extracting unicode text from Excel spreadsheet using VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related