>>Then I agree that you are right. The Help file states the behavior your pointing out as being the case.
>>"For an existing file, the default format is the last file format specified; for a new file, the default is the format of the version of Excel being used."
>>
>>This begs the question: What is the xlFileFormat for Excel 2003?
>
>Use Object Browser to pull Excel constants from the type library.
I did that already but I don't have a clue as to which code is the regular Excel worksheet.
ramil
~~ learning to stand still