Hi, I met the strange issue with scriptable component.
I try to write a table with a hyperlink to excel file. Everything is OK without hyperlink note "link"
If I add semicolon+"link", I get an unknown script error. Problem is in a semicolon.
File is attached
I changed my regional settings as described in this article
now, with comma everything is OK
Don't have an explanation or solution.
But if you put the lines
Set Cell = ws.Cells(2,1)
Cell.Value = "=hyperlink("C:\Temp.xlsx";"link")"
in your code (and omit the nested loops which throws the error) you get a more meaningful (??) error - at least its not the unknown error.