saving a csv file with unicode encoding

A

avashistha

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
 

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

VBA SaveAs function generates blank CSV file 4
Convert UTF-16 Unicode to UTF-8 Unicode? 1
Save Excel file to a CSV without opening it first 4
VB Help If Statement in Selection.ShowDetail = True 5
User prompt for CSV format 5
Properly Saving a .CSV File With an 11 Digit Numeric Field 2
Create CSV 5
Command Button to export a worksheet as a .csv file 1

Top