Thread: Excel VBA to save .xls file as UTF-8 text file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
match5man match5man is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote