This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
My son wrote a vba that creates a text string and then outputs it to a Unicode file. His output line is...
Print #2, StrConv (NewFile, vbUnicode)
It creates the new file okay except the file should begin with FF FE. The new file begins with FF 00 FE 00.
How do I go about fixing this? Thanks.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
My take on that is using Print causing the problem. Instead you should use the FileSystemObject approach to create/open the file and write out unicode text
Thanks for replying. It seems that the stackoverflow was talking about making changes to a file's title, whereas I'm trying to have Excel write the first two bytes in a unicode file as FF EE and not FF 00 FE 00.
A unicode file's first two bytes tell what type of file it is... and FF FE is a Unicode UTF-16 Little Endian file. I'm not an expert by any means... just trying to get my son's code working properly.
After the file is written by Excel, I have to load it into Notepad and delete the first 2 characters that show up at the start of the file, and then save it. This removes the FF 00 FE 00 and replaces them with FF FE.
See the replies in this stackoverflow question about vba files and unicode