Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Automation Error Overlapped I/O operation is in progress

Status
Not open for further replies.

KM8888

Programmer
Nov 21, 2011
69
US
Hi all,

One user has been experiencing this error that isn't recreatable by other users or myself and happens pretty frequently with them. It's happening in an Access Function where I pop-up a word document and automate some bookmarks within it. That error pops up and references this line

Set wordApp = CreateObject("Word.Application")

Now I'm thinking it's not so much a problem in the code and a specific CPU issue but the information about this is the most limited I've seen in a long while so I can't make much out of what's causing this or how to fix. Has anybody else encountered this? And what was done to fix? Responses always appreciated :)

Tks!
 
I would think you would get that error because you are not closing or de-referencing an object somewhere, you get it in C++ if you have unhandled return value, I would think at the VBA level it would be poorly structured exits or not closing an object used in a loop.
 
Thanks for the response! Yeah I'm not sure, there's no looping being done and I do release the word objects at the end of execution so it's a bit bizarre. I implemented calling the code from a vbs as a work around and that seemed to work :S
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top