Excel VBA to save .xls file as UTF-8 text file

M

match5man

I am currently writing an Excel VBA for manupicating an excel file an
then save as a tab delimited file. I have successfully use th
following code to save it as unicode text file.

ActiveWorkbook.Save
ActiveWorkbook.SaveAs filename:= _
filepath & filename & ".txt", FileFormat:= _
xlUnicodeText, CreateBackup:=False
ActiveWorkbook.Close

However, I would like it to save as UTF-8. Is there anyway I coul
handle this? Thanks ^_^:confused
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert UTF-16 Unicode to UTF-8 Unicode? 0
Convert UTF-16 Excel file to UTF-8 and back 1
How can I export txt(UTF-8 characterset) from Excel? 4
Hiding an Excel file using VBA 1
Save As xls to text (tab delimited) in encoding utf-8 0
UTF-8 File Opened in Excel from Firefox Browser 1
Text File Encode to UTF-8_Unicode specific 1
Saving as Sheet as a Tab Delimited Text file 2

Top