RunAddonWArgs

[Tom Briers]

Hi all,

I have a bizare problem.
I have some events that are triggered in the EventDrop.
I use the formule: RUNADDONWARGS("ShapeHandler.exe","/name=value")
On some computer this works on other computers I have to replace the ","
with a ";".
So the formula looks like this
RUNADDONWARGS("ShapeHandler.exe";"/name=value")
Does anybody know how this comes and how I can make shure that the formula
is always correct.

Thanks in advance

Tom Briers

 

[Kari Yli-Kuha]

Hi all,

I have a bizare problem.
I have some events that are triggered in the EventDrop.
I use the formule: RUNADDONWARGS("ShapeHandler.exe","/name=value")
On some computer this works on other computers I have to replace the ","
with a ";".
So the formula looks like this
RUNADDONWARGS("ShapeHandler.exe";"/name=value")
Does anybody know how this comes and how I can make shure that the formula
is always correct.

It depends on your regional settings and is the value of ListSep() shapesheet function.
In the US the "list separator" is ';' and e.g. in Finland ','

If you're writing the formula from VB(A) try using Cell.FormulaU property
instead of plain Formula, and use ',' as the separator.

/C