Re: USD $20.00 Excel print word vba automation via paypal
The problem occurred again yesterday, here's what actually happens, in the case where the document to be printed is the only one opened:
- Excel says "Excel is waiting for an OLE object......", and when you click OK it pops up again.
- There are no word documents open, but WINWORD.EXE is still running.
- Killing WINWORD.EXE is the only way to stop the Excel dialog box.
- The document does not print.
Since the code has got to the point where the document has been closed, I assume that Application.BackgroundPrintingStatus has been set to 0 even though the document has not printed. The document has then been closed even though Excel is still waiting for some kind of signal from it. The only answer I can see is to leave the document open which is not great but I'm not sure what else I can do. I cannot see that your revised code addresses this issue. Give me your paypal and I'll give you $10, and another $20 if you can solve this problem.