Richard H.
Administrator
   
Registered: 2000-01-24
Posts: 4946
Loc: Leatherhead, Surrey, UK
|
The value is a constant (aka enumeration), which is translated from the text value to an internal numeric value by the scripting or programming language.
KiXtart does not have access to these constants, so you have to do the translation manually.
Sometimes they are a bugger to find, and the only way to do it is to use an object viewer.
For reference, the xlFileFormat values for Excel 2002 are:
Quote:
typedef enum { xlAddIn = 18, xlCSV = 6, xlCSVMac = 22, xlCSVMSDOS = 24, xlCSVWindows = 23, xlDBF2 = 7, xlDBF3 = 8, xlDBF4 = 11, xlDIF = 9, xlExcel2 = 16, xlExcel2FarEast = 27, xlExcel3 = 29, xlExcel4 = 33, xlExcel5 = 39, xlExcel7 = 39, xlExcel9795 = 43, xlExcel4Workbook = 35, xlIntlAddIn = 26, xlIntlMacro = 25, xlWorkbookNormal = 0xffffefd1, xlSYLK = 2, xlTemplate = 17, xlCurrentPlatformText = 0xffffefc2, xlTextMac = 19, xlTextMSDOS = 21, xlTextPrinter = 36, xlTextWindows = 20, xlWJ2WD1 = 14, xlWK1 = 5, xlWK1ALL = 31, xlWK1FMT = 30, xlWK3 = 15, xlWK4 = 38, xlWK3FM3 = 32, xlWKS = 4, xlWorks2FarEast = 28, xlWQ1 = 34, xlWJ3 = 40, xlWJ3FJ3 = 41, xlUnicodeText = 42, xlHtml = 44, xlWebArchive = 45, xlXMLSpreadsheet = 46 } XlFileFormat;
xlWorkbookNormal is a very large unsigned number, which appears to be a negative value when used in a signed data type.
|