English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

1 answers

MSO = MicroSoft Office

msofiletype is an enumerated list of Microsoft Office formats. Emphasis on Microsoft and Office.

To save an Excel work book as csv use the XlFileFormat enumeration found in the MSO Interop for Excel.

Following is VB2005

Dim wkbk As Microsoft.Office.Interop.Excel.Workbook

'More code here to properly open XL workbook

With wkbk
Dim MyxlFileFormat As Microsoft.Office.Interop.Excel.XlFileFormat

MyxlFileFormat = Microsoft.Office.Interop.Excel
.XlFileFormat.xlCSVMSDOS

.SaveAs("Test2CSV", MyxlFileFormat)

end with

The following is the enum option for Windows CSV format
the above lines of code are getting truncated by Yahoo.

XlFileFormat.xlCSVMSDOS

2007-11-09 09:40:27 · answer #1 · answered by MarkG 7 · 0 0

fedest.com, questions and answers