run-time error '-2147221040 (800401d0)'

[joe.afusco]

Getting run-time error '-2147221040 (800401d0)':

DataObject:PutInClipboard OpenClipboard Failed

Any workaround on this error?

Macro takes everything currently on the clipboard, parses through it, pulling specific pieces out, then pastes it into excel. Get this error every time.

 

[migforce]

Getting run-time error '-2147221040 (800401d0)':

DataObject:PutInClipboard OpenClipboard Failed

Any workaround on this error?

Macro takes everything currently on the clipboard, parses through it, pulling specific pieces out, then pastes it into excel. Get this error every time.

Did you ever solve this?
Thanks.

 

[joe.afusco]

Did you ever solve this? Thanks.

We do still get this error from time to time. We run the macro that uses open clipboard roughly 15k times a day. Restarting the station helps fix it. When the issue was more consistent, I noticed the guy who wrote the code for us didn't kill off his variables on completing execution of the code. Maybe try that?