open text file OK But what does the code mean in English?

[PeterTaylor]

Dear all,
below is a snippet of code that I used to open text files:

Application.Workbooks.OpenText MyList.Value, xlMSDOS, 1, xlDelimited, xlDoubleQuote, Tab:=True, _
                    FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1))

The code works well but I don't really understand what is asking Excel to do, in particular what do the "XLMSDOS", "XLdelimited", "XLdouble quote", and an "field info" mean in plain English.
Regards,
Peter

 

[Andrew Poulsom]

Here is a description of the OpenText method and its arguments:

https://msdn.microsoft.com/en-us/library/office/ff837097(v=office.15).aspx

 

[PeterTaylor]

Here is a description of the OpenText method and its arguments:

https://msdn.microsoft.com/en-us/library/office/ff837097(v=office.15).aspx

Dear Andrew,
thank you for the link; the way I read this "fieldinfo" array statement is that I am setting col 1 -> 6 to General format and any other fields will be set to the default "General". Is this correct; if so the statement as written is redundant n'est pas.
Regards,
Peter

 

[Andrew Poulsom]

Yes that's right. The FieldInfo argument is optional and needn't include all the fields if used, although see the caveat in Post #5 here:

http://www.mrexcel.com/forum/excel-...ions-texttocolumns-fieldinfo-not-working.html