Ask a new question

dataobject:putinclipboard openclipboard failed in VBA

Hi ,

We are having VBA code to generate the report in excel format.it was running till excel 2013.

Now migrated to excel 2016 and resolve issue related to images .But in change it is giving the error on some of the user systems.

Error is dataobject:putinclipboard openclipboard failed .Code is as below:

dataobje.setText ""

dataobject.putinclipboard

When we tried to put message box it is running fine without error.but when tried Sleep and wait functions , did not work.

Can you please help me on this.
Please suggest if any code change or any windows patch or registry change


A noticed a curious bug after upgrading from Windows 7 to Windows 10 (same issue with Windows 8.1 environment); close all MS File Explorer windows then run your code.

Others have solved with Windows API workaround -- see

https://msdn.microsoft.com/en-us/library/office/ff192913.aspx

11 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

The bug is with the .putinclipboard method.

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 2, 2024 Views 5,943 Applies to: