After A Reinstall of Office, My Macros Get Multiple Errors

[macropod]

Originally Posted by Stephen Ray

Clipboard.SetText “John Doe” (only this line is highlighted in yellow)

Evidently, you've stored this content in a Word document, where your VBA straight quotes have been converted to smart quotes. Change:
Clipboard.SetText “John Doe”


to:
Clipboard.SetText "John Doe"

[Stephen Ray]

Macropad, It took me several readings to see the difference in the quotes. I must go study that.
And in running the Macros, the errors seem to be spontaneously correcting themselves. I have changed only one thing where I took out a backspace before I copied it. I don't see how that could have changed anything else.
I run at least 20 different Macros every day again and again.
It is as if the Macros are magically improving, but I don't believe in magic.
I will keep you informed, I will get back to it on Monday.
Thank you.

[Stephen Ray]

MacroPod, Evidently, before the 2016 install, I had set it so spaces were not appended to a paste. The install set things back to the default settings, so I fixed it with:
Microsoft Word, 2016
File, Options, Advanced,
Cut, copy and paste
Uncheck the box – Adjust sentence and Word spacing automatically
Please see attachment for a picture of the above.

It will take me some time to use the Macros to regain confidence that things are fixed. I will keep you informed. And I study your Smart Quotations idea too. Thanks!

[Stephen Ray]

I am still cleaning it up.
I set Microsoft Word 2016 so that it will not append spaces before and after the pasted text, but there are still little differences with the cursor movement. Where I get errors, I trace it back to cursor movement. Sometimes a difference of one space makes a difference when the Macro finds some text, then moves the cursor from the highlighted text, over two spaces instead of three. -For some reason this is the difference from the previous install.

So we are finished here. It was just awful when my Macros weren't working. I thought it was some kind of VBA Syntax change with the new 2016 version.