Access Automation of Excel (closes at random) 
Author Message
 Access Automation of Excel (closes at random)

We are trying to use automation from Access 2000 to Excel 2000 to create
multiple pivot tables in a workbook. Each pivot table is created in a
seperate worksheet.
The first five tables create fine, but the sixth (which has no major
differences, technically) causes Excel to close. No messages or DrWatson
errors are created by Excel. Access then comes up with an error to say that
the automation server is not responding (which it can't because it's gone!).
Sometimes, although rarely, the whole process works.

Is there some way we can find out why Excel is closing (there are no
requests to close it in the program) or does someone know what this problem
is caused by?

Vince Cullip

Mon, 22 Dec 2003 14:14:11 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Access/Excel Automation - Excel Not Closing

2. Access/Excel Automation - Excel Not Closing

3. Excel closing after closing workbook (OLE automation)

4. Excel won't close from Access Automation

5. Close Excel With Access Automation (ever so popular problem)

6. VB Automation with Excel does not close Excel instance

7. Excel Automation - Problem closing instance of Excel from with Access2000

8. Closing Excel with VB automation

9. Missing OLE Automation and File Closing(Excel 97)

10. Automation Does Not Close Microsoft Excel

Powered by phpBB® Forum Software © phpBB Group