'1004 Excel cannot paste the data' - Copying from SAP new issue

[marc81]

Hi,

I have created a few tools in Excel that use VBA to access SAP, copy data from SAP then paste it back in to an Excel workbook. They have been working fine for a couple of years, but now whenever they get to the activesheet.paste I am getting error 1004 'Excel cannot paste the data'. The odd thing is that if you debug and hit F5 it pastes the data and carries on fine. The macro also works fine if you have the VBA window open. I've tried writing new scripts and get the same issue. Any ideas why this would happen all of a sudden?

Thanks,

 

[FuNeS13]

your script copies data from SAP and pastes it into excel? wanna share your code to take a look? (I use scripts to access SAP via VBA as well).

 

[BSALV]

try to slow down the process at your critical point(s).
By adding "Doevents" you force everything to synchronise, but even then it's not always enough.
stupid example

   Range("B1").Copy
     DoEvents
     Range("C1").PasteSpecial xlValues

Can you give the 5 last lines before that error.