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