Unterminated string constant windows script host vbscript error

1
votes

I am getting an error unterminated string constant 800A0409 from windows script host because of the "em dash" character —. It seems to work fine from other computer there were no errors and also when I copy paste the em dash symbol in excel VBA it turns into a "?". I have tried using the ASCII equivalent; when doing so I did not get the error but instead getting a weird character: ‿

Code: 

If InStr(xLine, "—" ) > 0 Then
    ReplaceEmDash = Replace(xLine, "—", "-")

Any tips?

1
vbscript

1 Answers

0
votes

Maybe this should work

Dim EmDash
    EmDash = ChrW(&h2014)

If InStr(xLine, EmDash) > 0 Then
    ReplaceEmDash = Replace(xLine, EmDash, "-")
....