Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Message
I am have a spreadsheed that uses macros to manipulate a matrix of text and
pictures. Until recently it was working fine. I use one matrix to manipulate the data into the desired format. After I run this, nothing runs. I get the message "Object library invalid or contains references to objects that could not be found." There are no hints as to how to debug this. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Message
after the error, go to tools=References in the VBE and see if you have a
reference marked as MISSING. If so, then this would be the cause of your problem (it will need to be fixed). If not, what has changed since it was last working. -- Regards, Tom Ogilvy "ZipCurs" wrote in message ... I am have a spreadsheed that uses macros to manipulate a matrix of text and pictures. Until recently it was working fine. I use one matrix to manipulate the data into the desired format. After I run this, nothing runs. I get the message "Object library invalid or contains references to objects that could not be found." There are no hints as to how to debug this. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Message
No code, so I'm not sure what you are trying to do or what you mean by a
"matrix of text and pictures". However, check the References in your project for any marked "MISSING". Also, you can use the Object Browser to check the methods/objects etc available in the libraries that you have referenced. NickHK "ZipCurs" wrote in message ... I am have a spreadsheed that uses macros to manipulate a matrix of text and pictures. Until recently it was working fine. I use one matrix to manipulate the data into the desired format. After I run this, nothing runs. I get the message "Object library invalid or contains references to objects that could not be found." There are no hints as to how to debug this. Any help would be appreciated. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Message
Thank you for getting back. The macro now works. I am pretty sure that all
I did between failure and working was reboot the computer. The part of the macro that appeared to be failing was associated with CheckBoxes. Any further thoughts would be welcome. "Tom Ogilvy" wrote: after the error, go to tools=References in the VBE and see if you have a reference marked as MISSING. If so, then this would be the cause of your problem (it will need to be fixed). If not, what has changed since it was last working. -- Regards, Tom Ogilvy "ZipCurs" wrote in message ... I am have a spreadsheed that uses macros to manipulate a matrix of text and pictures. Until recently it was working fine. I use one matrix to manipulate the data into the desired format. After I run this, nothing runs. I get the message "Object library invalid or contains references to objects that could not be found." There are no hints as to how to debug this. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace VBA run-time error message with custom message | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
Excel XP error message Run Time Error 91 | Excel Programming | |||
changing the message in an error message | Excel Worksheet Functions | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |