OpenText Method FieldInfo Arrays

I recorded the following macro opening a .csv file
(then I modified the filename)

The number of rows in the .csv file changes every day.
It seems to work properly everytime I run it but I don't understand the FieldInfo Arrays.
Consequently my concern is will the code not function as desired some day if the .csv file gets too long?

Please Login or Register  to view this content.

Hello Carstowal,

You need not worry about the file's length increasing, only the width. The FieldInfo argument is a two dimensional array. The first element is the Column number, and the second is an Excel parsing constant.

Remarks (from the help file)
FieldInfo Optional Variant. An array containing parse information for individual columns of data. The interpretation depends on the value of DataType.

When the data is delimited, this argument is an array of two-element arrays, with each two-element array specifying the conversion options for a particular column. The first element is the column number (1-based), and the second element is one of the xlColumnDataType constants listed in the following table, specifying how the column is parsed.

Sincerely,
Leith Ross

Thank you
my newbie comprehension of the Help File was not adequate
I feel much more confident now!