How to use VBA Code to Clear All on Clipboard?
Have tried answer to
How to Clear Office Clipboard with VBA
But that comes up with error message “User Defined Type not Defined”
I have several Macros in Word utilising clip board.
Recently Copy and Paste stopped functioning, the Copy simply did not register on the Clipboard.
Then a few key strokes later, the Copy feature would return again,
Other times it would return only after operating some other macros.
I found that “Clear Clipboard” was a reliable way of reactivating the Copy function, but can’t find a way to activate via VBA. Some of VBA script on line were incredible complex series of 3 Subs & Functions.
The same could be achieved via Windows: this works as a Shortcut file:
%windir%System32cmd.exe /c “echo off | clip”
OR
This works from Command prompt:
cmd.exe /c “echo off | clip”