View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Saving a column of data in another file format

Help is designed to support the way one would normally look for help. If you
wanted to find help on saving files, you would look for help on save or save
as. You would probably have no knowledge that xlTextMSDos even existed as a
constant.

You can however go to the Object browser, select the excel library and
search for xlTextMSDos and it comes right up. You can see that it is part
of the constant group xlfileformat. Unfortunately, that does not lead you
directly to Saveas but you could search then on FileFormat (which does take
you to the list of fileformats).

Once you were familiar with the help on SAVEAS, you would remember the link
to fileformat and see what constants were available.

--
Regards,
Tom Ogilvy


"Hari Prasadh" wrote in message
...
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" wrote in message
...
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)