ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error Message (https://www.excelbanter.com/excel-programming/372584-error-message.html)

ZipCurs

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.

Tom Ogilvy

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.




NickHK

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.




ZipCurs

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.






All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com