Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
RunTime Error (Automation Error) | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming | |||
Unknown where is the problem on the Runtime error - Automation error | Excel Programming |