| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an excel file as a file with undelimited text | Excel Discussion (Misc queries) | |||
| Why cant I save as a text file in excel? | Excel Discussion (Misc queries) | |||
| How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
| Save CSV file as Pipe delimited text file | Excel Discussion (Misc queries) | |||
| How can I save a file as a comma-delimited text file in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
