Hi Bob,

> I guess the reason is that xlTextMSDOS is an Excel constant,...

I lost you there. If its not a Excel VBA but an excel constant then atleast
in the normal excel file help if i type -- xlTextMSDOS -- it should show,
but it doesnt. Im losing track of ur explanation somewhere.

Thanks a lot,
Hari
India

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:eqSO6PvBFHA.2600@TK2MSFTNGP09.phx.gbl...
> Hi Hari,
>
> I guess the reason is that xlTextMSDOS is an Excel constant, not a VBA
> constant, so you don't see it in VBA help. But SaveAs can save in many
> formats, so it provides a link of the available formats. To check this, I
> just opened Word, and went into Word VBA and looked up SaveAs. I expected
> to
> see the same help, but FileFormat to show me a different list. IT was very
> similar, but it had a link called SaveAsFormat, not FileFormat. But the
> rest
> was as expected.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>