Most of this is explained in the help file in great detail. I would start
there and then ask for explanation.

Most of this reflects the choices you made when you went throught the text
import wizard. For instance, at the start of the wizard is the Choice start
at line and a textbox. You entered 1 and it is recorded as

Startrow:=1

From you description, that is what you want.

For the remainder, begin in Help. But as an example, for me, help only
shows the values 1, 2, or 3 for Origin.

? xlMSDOS
3
? xlWindows
2
? xlMacintosh
1


You may have more because you don't have an English version of Excel
(assumed).

--
Regards,
Tom Ogilvy


"Hari" wrote in message
...
Hi,

Im trying to programmatically open a textpad kind of file (and then save
it
as excel file) and I recorded a macro for the same. The relevant line is
....

Workbooks.OpenText Filename:= _
"C:\Documents and Settings\abc\Desktop\dev11022.xls", 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

I wanted to understand
a) What "Origin" means
b) Is Startrow the row from which textpad will be read?
c) I want to export whole of the textpad in to excel without any
exclusions
in such a way that each row in the texpad occupies a single cell in Excel.
In view of that would it be more safer if I remove the specification of
TextQualifier:=xlDoubleQuote. If yes, what value should I put following
the
equal to sign in the text qualifier statement.
d) What does FieldInfo:=Array(1, 1). Based on my requirement mentioned in
point c) does the specification in Fieldinfo pose a danger for all my data
not getting transferred.
e) What does TrailingMinusNumbers:=True mean. Again does the trailing
minus
number specification affect the amount and the way that gets stored in
each
cell of the excel.


Thanks a lot,
Hari
India