OT: Any VBS, VBA, Excel specialist out there who might help?

[Ken Ray]

> as i already said, i am not very familiar with vbs. My script is from
> a book.
> 
> So i am not sure, how and where in the script i should pass this
> parameter.
> 
> Regards
> 
> Matthias

Oh geez, Matthias.... I haven't had a chance to read the list for a while
and just caught this, so I hope I can still help after all this time has
passed.

Anyway, here's what you need to do:

Instead of this line of code that you have right now:

.Workbooks.OpenText sInPath, , , ,xlTextQualifierNone,,,True,,,,
,Array(Array(1, 2), Array(2,2), Array(3,2), Array(4,2), Array(5,2),
Array(6,1), Array(7,1), Array(8,1), Array(9,1), Array(10,1),
Array(11,1), Array(12,2))

pass this one instead (watch the line breaks):

.Workbooks.OpenText sInPath, , , xlDelimited,xlTextQualifierNone,,,
True,,,,,Array(Array(1, 2), Array(2,2), Array(3,2), Array(4,2), Array(5,2),
Array(6,1), Array(7,1), Array(8,1), Array(9,1), Array(10,1),
Array(11,1), Array(12,2))

Let me know if this works for you,

Ken Ray
Sons of Thunder Software, Inc.
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/