Excel VBA to save .xls file as UTF-8 text file
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 -- Message posted from http://www.ExcelForum.com |
All times are GMT +1. The time now is 01:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com