I’m using the (Invoke VBA) activity to paste an formula which contains special tokens. When I’m running the VBA script in Excel it’s working fine. But when I use the (Invoke VBA) activity the activity is replacing the ’ token for the following tokens â€™.
The text should be: C KPI’S EN WERKGEBIEDEN
And after running the text is: C KPIâ€™S EN WERKGEBIEDEN
Anyone know how to solve this issue?
Thank you in advance!