Importing Text Files: FieldInfo - Array's

[exc4libur]

Hi,
The code below will import text file's to excel and structure columns according to the arrays.

Please Login or Register  to view this content.

What I was uncapable of doing was to substitute the wide selection of Array's(10, 1), Array(24, 2), Array(82, 1), Array(95, 1), etc... for something more simple and efficient. Maybe using a loop or something which I am less familiar. Below is a piece of code I tried to use in the code above but I didn't have much success. Any help would be appreciated!

Please Login or Register  to view this content.

Thanks

[exc4libur]

I tried using the second code from this link http://www.excelforum.com/excel-gene...parameter.html.

Any help please?