SCP mishandling pair-closing character inside string literal

[SonGokussj4]

Rubberduck version information
The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box:

Version 2.5.0.5249
OS: Microsoft Windows NT 10.0.19041.0, x64
Host Product: Microsoft Office x86
Host Version: 16.0.12228.20364
Host Executable: EXCEL.EXE

Description
myString = "Beginning |"
Type "
Becomes: myString = "Beginning"| "
Expecting: myString = "Beginning "|

[bclothier]

A similar case can be made for where carets is in middle of a line:

Initial:

foo| "bar"

Type ( yields:

foo(|) "bar"

In this case, I typically want to end up with:

foo("bar")

IOW, I would prefer that SCP not complete if the caret is in middle of something.

[IvenBach]

I enjoy SCP. I agree with @bclothier on this (bad pun). This is an instance where I find it #OverlyHelpful at times. I battle with this quite often.