Microsoft Office Excel is waiting for another application to complete an OLE action

@theavinash-DAs260 • Oct 26, 2024

Oct 26, 2024

1.4K

I need to do some operations on excel file having size more than 4GB. I have written VBA code to automate the operations. But while opening the file using code it takes more time and it shows pop up stating-
"Microsoft Office Excel is waiting for another application to complete an OLE action". I dont want this pop up. Suggest me ways to handle it.

Like 0 Replies 2

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

pittypan

@pittypan-7BouXL • Feb 20, 2014

theAvinash
I need to do some operations on excel file having size more than 4GB. I have written VBA code to automate the operations. But while <a href="https://www.rasteredge.com/how-to/vb-net-imaging/excel-get-to-start/" target="_blank" rel="nofollow noopener noreferrer">VB.NET Excel: How to Create, Load & Save Excel Doc in VB.NET</a> using code it takes more time and it shows pop up stating-
"Microsoft Office Excel is waiting for another application to complete an OLE action". I dont want this pop up. Suggest me ways to handle it.
I think if it is related to Excel, you may try to find some suggestions in Microsoft support forum. Like this one:

#-Link-Snipped-#
Manish Goyal

@manish-r2Hoep • Feb 21, 2014

theAvinash
I need to do some operations on excel file having size more than 4GB. I have written VBA code to automate the operations. But while opening the file using code it takes more time and it shows pop up stating-
"Microsoft Office Excel is waiting for another application to complete an OLE action". I dont want this pop up. Suggest me ways to handle it.
I think it is because of problem in your VBA script, remove the script then check if you are still getting same error