Microsoft Excel is waiting for an OLE action to complete

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top