EXCEL Text to Columns macro with a variable numberof Fields

[Keebellah]

Hi Guys,
I've go a question again about something that I can't seem to put together.

The code below works fine for the 41 columns and does exactly what it needs to do

Please Login or Register  to view this content.

What I am trying to figure out is how can y use variable list of fields for the FiledInfo

I have this routine in the macro that checks how many columns are in the first row of the importet text file

Please Login or Register  to view this content.

The contents of fInfoArrList will vary in relation to the what the text file contains

Please Login or Register  to view this content.

The question is how can this be made to work?

Hope my explanation makes sense
Thanks for looking and any ideas or tips are welcome.

[TMS]

Instead of building a string, why not ReDim an array the size you want and then loop through it making each entry in the array represent a column … much as you have done with the string. That way, you end up with an array. Hopefully you can use that in the text to columns.

Totally untested but an idea to play with.

[romperstomper]

Yes, you need an array whose elements are themselves arrays.

[Keebellah]

Thanks @TMS adn @rorya, the array, yes, that's tru a single array, I was confused by the Array(1,1) all I need then is one dimentional array .
I'm off to be now and will look and test tomorrow, I was making it more difficult than it really is.
Thanks again, will update tomorrow (if I get it done) and will also post the code snippet
Good-night

[romperstomper]

A 1D array of arrays to be specific.

[Marc L]

Hi,

as FiedInfo parameter is optional and according to the initial post code as all columns are set to general so it is useless, can be removed !

When this parameter is really necessary - for example to convert dates - you can use an array for the non general columns …

[Keebellah]

@Marc L: I agree and this is the default setting, once I get that working I have a table that checks the ghearder name where it reads if it's a date or a general or specific text setting, thta's why I'm trying to figure it out
Tried array one D and 2D but it doesn't work

My last attempt as 2D array no go either

Please Login or Register  to view this content.

Thanks anyway, will find another way

[romperstomper]

2D is wrong. You need a 1d array and each element of that is also a 1D array

[Keebellah]

Hi guys, thanks and i got it working, now only the finetuning but thanks

Please Login or Register  to view this content.