Thanks for taking the trouble to answer. Once I understood that I needed to
pass the Field Info, defining it as an Array held in variant datatype it all
fell into place and now works fine


"Leith Ross" wrote:


Hello Sue,

The problem is with passing the array. In your Sub you're passing it as
a String. The Array must be a Variant. I have highlighted the problem in
red.

Sub texToWB(Wb As String, Textfile As String, Arr As String, GrpId As
String)

Change it to read...
Sub texToWB(Wb As String, Textfile As String, Arr As Variant, GrpId As
String)


--
Leith Ross


------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=478205