File Format Property Read Only Long

This property returns the file format or type of the workbook. It can be one of the following

XlFileFormat constants:

Enum XlFileFormat xlAddIn = 18 xlCSV = 6 xlCSVMac = 22 xlCSVMSDOS = 24 xlCSVWindows = 23 xlCurrentPlatformText = -4158 xlDBF2 = 7 xlDBF3 = 8 xlDBF4 = 11 xlDIF = 9 xlExcel2 = 16 xlExcel2FarEast = 27 xlExcel3 = 29 xlExcel4 = 33 xlExcel4Workbook = 35 xlExcel5 = 39 xlExcel7 = 39 xlExcel9795 = 43 xlHtml = 4 4 xlIntlAddIn = 26 xlIntlMacro = 25 xlSYLK = 2 xlTemplate = 17 xlTextMac = 19 xlTextMSDOS = 21 xlTextPrinter = 36 xlTextWindows = 2 0 xlUnicodeText = 42 xlWebArchive = 4 5 xlWJ2WD1 = 14 xlWJ3 = 4 0 xlWJ3FJ3 = 41 xlWK1 = 5 xlWK1ALL = 31 xlWK1FMT = 30 xlWK3 = 15 xlWK3FM3 = 32 xlWK4 = 38 xlWKS = 4

xlWorkbookNormal = -4143 xlWorks2FarEast = 28 xlWQ1 = 34

xlXMLSpreadsheet = 46

End Enum

0 0

Post a comment