Seting TextCodepage property of WorkbookSaveAsArgs (Workbook) object

Go To StackoverFlow.com

2

Folks, I'm trying to set the TextCodepageproperty of WorkbookSaveAsArgs used as argument for an Workbook method SaveAs. Which is used to convert .xls files in .csv ones. However, this property receives a generic object and I don't know how to properly set it. In msdn documentation it only say Ignored for all languages in Microsoft Excel. or Not used in U.S. English Excel.. When my documents are being convert, it generate invalid characters cause my input files are in portuguese. Thus, I need a encode mode that accept this language. Any suggestions?

2012-04-05 18:35
by João Paulo Navarro


4

I can only suggest saving with FileFormat:=xlUnicodeText, instead of xlCSV. But use a ".csv" file extension when you do so. This should preserve your portuguese characters.

2012-07-20 02:46
by midspace
Ads