Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE Automation
I have developed many applications using both Access and Excel as the base platform to automatically generate reports in Word using OLE Automation. I have noticed that repeated attempts to run the automatic report generator from either Access or Excel result in automation errors. These errors can only be fixed by re-booting the computer. Can anyone tell me what I'm doing wrong? Is there a way to prevent these automation errors? They can be a real nuisance?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OLE Automation
Bob C. wrote:
I have noticed that repeated attempts to run the automatic report generator from either Access or Excel result in automation errors. These errors can only be fixed by re-booting the computer. Can anyone tell me what I'm doing wrong? Try monitoring using Resource Meter or similar as you run the reports. I have experienced resource leaks when using automation to Word to create reports. I seem to recall getting an improvement by closing Word every N reports and re-opening it (but that could have been in an old version and no longer necessary). Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automation | Excel Discussion (Misc queries) | |||
Automation | Excel Worksheet Functions | |||
Automation?? | Excel Discussion (Misc queries) | |||
automation | New Users to Excel | |||
Automation | Excel Programming |