>OK - here the scoop: .market is defined as c(50)
>If I do this -
>lcname = TABLE.market
>oWorkS1.name = lcname
>Gets me OLE error everytime.
>
>If I TRIM(TABLE.market) it works OK! or just pass it
>the LEFT 10 chars it's OK. I guess I there is a
>length limit on the .name!!!!!!! Anyone know what it is?
The max length for a tab name in Excel is 31 characters.