Look up Help from the VBA Editor. (Ensure you are in the VBA editor not a
worksheet because they are two different help files).

Enter 'opentext filename' for the search and you will see a list of all the
parameters or arguments and descriptions.

Text files often need the data to be separated into columns and if opened
manually, you do this with 'Text to Columns'. When doing this you can set the
data type of various columns as dates etc and the array holds the column
number and the data type of the column.

How many and which arguments you need depends on the text being imported.

Regards,

OssieMac



"Sören_Marodören" wrote:

I'm looking for information about the parameter FieldInfo that is used below:

Workbooks.OpenText Filename:=HelaFilNamn(i), _
Origin:=xlMSDOS, StartRow:=1, _
DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, _
Tab:=True, Semicolon:=False, _
Comma:=False, Space:=False, _
Other:=False, DecimalSeparator:=",", _
FieldInfo:=Array(1, 1), _
TrailingMinusNumbers:=True

What is it used for?
Can you use something else then arrays?
Do I need it?
When do I need it?

Best regards,
/Sören