Microsoft Excel is waiting for an OLE action to complete

[Guest]

hi,
Actually i am having a template in word with bookmarks to be replaced. The
actual values for the bookmarks are stored in the excel sheet.According to
the users choice suitable values from the excel sheet replaces the bookmark
in the word template.I have written macros in excel for this purpose which
runs by clicking a button in excel sheet.My problem is occationally i get a
error msg displaying "Microsoft Excel is waiting for an OLE action to
complete" after certain amount of time the application runs and gets
completed successfully. I would like u guys to give me a solution for this
problem as soon as possible.
regsrds
Nc

 

[Guest]

I think that we would need to see the code to give any comments.

 

[Simon Murphy]

Arun
it sounds like Word is taking time to update, or firing up a message box?
This often happens if you have lots of bookmarks or big data transfers.
Be sure to use 'doevents' in your code regularly maybe before and after each
call to the word object?
If that doesnt fix it then the best quick fix is probably to put a few
application.waits in your excel code to give Word chance to catch up

cheers
Simon

Blog: www.smurfonspreadsheets.net
Website: www.codematic.net Excel development, support and training