Invoke VBA is replacing ' to ’

Hi all,

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 ’.

For example:
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!