Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 144
Default Automation Error - Element Not Found

Hello,
I have a program that creates documents from an existing template. Some
times these files get pretty large. It looks like page 22 is the majic
number for bombing out. By page twenty to the worksheet is on row 1145, and
it has used 401 text boxes and two control buttons. Obviously a very large
file. If the program needs to go any further it will give me:

Run-Time Error -'2147319765(8002802b)'
Automation Error
Element not found.

I can hit debug and then immediatly press the play button and it continues
on its happy way until it gets to the next page and its the same thing. If I
continue to debug and press play until its finished the workbook looks fine
but isn't. There is a command button sheet that when it is clicked the macro
doesn't run. So I went into the VBEditor and tried to run it from there and
I get:

Compile error:
Object library invalid or contains references to object definitions that
could not be found.

I checked out the references and it looks to me like all the proper
references are checked so I don't know what thats all about.

I can send you the code and the workbook template if you like, but I'll have
to send that via email.

Thank you very much for your help,
Jordan
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting instances of found text (Excel error? Or user error?) S Davis Excel Worksheet Functions 5 September 12th 06 04:52 PM
RunTime Error (Automation Error) KD[_3_] Excel Programming 3 January 25th 05 01:56 PM
Automation Error, Unknown Error. Error value - 440 Neo[_2_] Excel Programming 0 May 29th 04 05:26 AM
Unknown where is the problem on the Runtime error - Automation error wellie Excel Programming 1 July 10th 03 08:12 AM


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"