Help on worksheet functions in the VBE are, as you observed, using the same
file as in Excel itself. so there is no specific help on using individual
worksheet functions in VBA.

Regards,
Tom Ogilvy

"Hari Prasadh" wrote in message
...
Hi Tom,

Thnx for the reply.

You would probably have no knowledge that xlTextMSDos even existed as a
constant.
I agree with that statement fully. Actually many times what happens is I
might have only a faint idea of a particular keyword/concept (Like I might
come across a new keyword/concept in NG post or some website or through
personal experimentation). In order to get a better idea of the same I
would
go to help. But it seems to be a catch-22 situation. In order to use Help
better you first need to have an idea of that so and so is part of a
bigger
concept/keyword (Like Save As is parent of Xltextmsdos). What Help assumes
is that one is privileged to know about Child, only if one knows about the
parent, or one follows the path through parent. This is somewhat alien to
me. Havent the MS folks created a Complete INDEX of all the words
(excluding
a, an, the etc) within Help?

To illustrate my point let me tell u this. Sometime back I was
programmatically opening a text file in XL and then saving it as a normal
Xl
file (I have pasted that code at the end). This I did through macro
recording. When i examined the code it showed me that -- Xlnormal -- is
the
syntax for saving a nonXL kind of file as XL.

Now, I wanted to learn more about this. So I typed --- xlnormal -- in Help
and I got the standard -- Please rephrase your question. What I want to
say
from this is that in this case I was aware to a certain extent about the
Child, which is --- xlnormal -- but Help doesnt let me directly *google*
it.
Seeing from the result I thought that probably --Xlnormal -- is not
documented in Help.

To add to the above I also couldnt understand that if I access Match
Function in VBA help, the same write-up comes up as in Excel Help. As far
as
I understand when Match is to be used within VBA then one uses
Application.worksheetfunction.Match (please correct me if am wrong) , so
shouldnt the examples documented for match function within VBA help be
presented in a way which is suitable to the way we use it in VBA.

I will start getting used to Object browser. As compared to help I find
those things a little sophisticated, not comfortable - but as they say....
If I use it a few times then the interface would seem a little more
intuitive.

Regards,
Hari
India


Sub RenamingLSTasXLS()

Workbooks.OpenText Filename:= _
"C:\Documents and Settings\abc\Desktop\Automate\Dev\From
Client\Raw
Data\week 1\dev11112.lst", Origin:=437, StartRow _
:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False,
Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(1, 1), _
TrailingMinusNumbers:=True

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\abc\Desktop\Automate\Dev\Working
Files\Renaming\dev11112.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

ActiveWorkbook.Close
Application.DisplayAlerts = True
End Sub