cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Unknown error of script with excel hyperlink semicolon

ifomenko
15-Moonstone

Unknown error of script with excel hyperlink semicolon

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

https://lockone.wordpress.com/2015/08/06/excel-now-using-semicolons-instead-of-commas-in-separating-formulas-fix-it-now/

now, with comma everything is OK

Screenshort.GIF

1 REPLY 1

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.

Top Tags