HI,

I have a piece ot code that opens 19 excel spreadsheets from access in
turn from within a loop.  About half way through I get the following
error:

"Run Time 429 - Activex component cant create object."

Any ideas why this falls over half way through the loop??  

Ta!

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.

So you got the open code working?

Does it do it when you step through the same number of iterations in the
debugger, slowly, allowing each excel automation command to complete before
moving on?  At what statement does it throw the error, after how many
iterations?





-----Original Message-----
From: Tim Maher [mailto:tim.maher@s...]
Sent: Tuesday, November 26, 2002 6:49 AM
To: Access
Subject: [access] Automating Excel From Access 429 Error


HI,

I have a piece ot code that opens 19 excel spreadsheets from access in
turn from within a loop.  About half way through I get the following
error:

"Run Time 429 - Activex component cant create object."

Any ideas why this falls over half way through the loop??  

Ta!

Tim
This e-mail transmission is strictly confidential and intended solely 
for the person or organisation to who it is addressed.  It may contain 
privileged and confidential information and if you are not the 
intended recipient, you must not copy, distribute or take any action 
in reliance on it.  
If you have received this email in error, please notify us as soon as 
possible and delete it.
This e-mail has been scanned using Anti-Virus software, however, 
Swansea NHS Trust accept no responsibility for infection caused by 
any virus received on the recipients system.