I cannot figure out for the life of me why I rarely get notifications of replies to my watched threads, but that is something else to sort out.

I tried you suggestion with my code with removed comments
 Code:
break on
call @ScriptDir + "\readexcel2.udf"
call @ScriptDir + "\isinarray.udf"

$Brandshop = readexcel2(@Scriptdir + '\pccs.xlsx',,-1,-1)

$NewArray = Array2Vector($Brandshop,1)
'Column A=' + Join($NewArray[0],', ') + @CRLF
@CRLF
'Column B=' + Join($NewArray[1],', ') + @CRLF

and the console returns
 Quote:
C:\Stuff\CopyCentral>kix32 ccn.kix
-1
ERROR : expected ')'!
Script: C:\Stuff\CopyCentral\ccn.kix
Line : 28


Line 28 correlates to
 Code:
$NewArray = Array2Vector($Brandshop,1)


Is the response which gives as -1 interferring with your code asI don't know where this is being generated? I have used the same readexcel2.udf in the other code I am using to read in the spreadsheet.

I've attached the UDFs as they have been included.

Thanks for your help on this. I really appreciate it.

Pax

Attachments
array2vector.udf (286 downloads)
Description:

readexcel2.udf (295 downloads)
Description: