ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   saving a csv file with unicode encoding (https://www.excelbanter.com/excel-programming/423037-saving-csv-file-unicode-encoding.html)

avashistha

saving a csv file with unicode encoding
 
Hi,
i am trying this from quite long time.

I have searched the msdn but could find a way to save the file not as
default ASCII but as unicode encoding
WB.SaveAs FileName:=ResultPath & "\" & testName & "_summary" & ".csv",
FileFormat:=xlCSV, CreateBackup:=False

WB.Close SaveChanges:=True


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com