Folks, I'm trying to set the TextCodepage
property 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?
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.