The sheet object does have a SaveAs method but I don't know why it exists
since it does the same thing as the workbook SaveAs method. It might be for
backward compatibility purposes.

I'd just use the workbook object and then you can use -4143. Btw, "1" is
not among the xlFileFormat named constants although it does seem to result
in a normal workbook.

--
Jim
"shrek" wrote in message
...
| Hi all,
|
| I use the Excel from C++ via automation and I try use SaveAs method of the
| WorkSheet object. The very strange thing is that it doesn't work with
| "xlNormal" (that is -4143) or with "xlWorkbookNormal" (that is -4143 too)
it
| gives some back some error code (0x800a03ec). BUT is works with value 1
| which is mentioned nowhere in the documentation or in the type library.
|
| Can somebody tell me why "xlNormal" doesn't work with WorkSheet's SaveAs?
| and what 1 means as file format constant? (it has to be some meaning
because
| Excel accept it)
|
|