Thanks Sergey,
You are always helpful as always. :)

Install Excel version is 2003. I get the following value of my file format "xlWorkbookNormal -4143".

Does that mean my excel file is in Excel 2003 format.
What do the following constants stand for? What is a constant for Excel 2003 format.

What does the mentioned below constant stands for?
xlExcel5 39
xlExcel7 39

Kindly suggest.
Thanks.


>

>? oExcel.ActiveWorkbook.FileFormat
>
>Constant Value
>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  44
>xlIntlAddIn  26
>xlIntlMacro  25
>xlSYLK  2
>xlTemplate  17
>xlTextMac  19
>xlTextMSDOS  21
>xlTextPrinter  36
>xlTextWindows  20
>xlUnicodeText  42
>xlWebArchive  45
>xlWJ2WD1  14
>xlWJ3  40
>xlWJ3FJ3  41
>xlWK1  5
>xlWK1ALL  31
>xlWK1FMT  30
>xlWK3  15
>xlWK3FM3  32
>xlWK4  38
>xlWKS  4
>xlWorkbookNormal  -4143
>xlWorks2FarEast  28
>xlWQ1  34
>xlXMLData  47
>xlXMLSpreadsheet  46
>
>

>>
>>
>>With the above mentioned code i am making necessary processing on the excel file. The Excel version i am using is Excel 2003 and i can open unprocessed and processed files in that excel version.
>>
>>When these processed files reached to the client he states that they are not Excel 2003 files but Excel 2000 or Excel 97 files. Any suggestions or method to know which Excel version a .xls file belong.
>>
><snip>