Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default 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
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
replace VBA run-time error message with custom message BEEJAY Excel Programming 13 July 14th 06 03:59 PM
error message: compile error, argument not optional Pierre via OfficeKB.com Excel Programming 3 September 5th 05 03:45 PM
Excel XP error message Run Time Error 91 Lenny[_3_] Excel Programming 1 March 3rd 05 10:15 PM
changing the message in an error message The Villages DA Excel Worksheet Functions 2 February 18th 05 05:30 PM
How do I get rid of "Compile error in hidden module" error message David Excel Discussion (Misc queries) 4 January 21st 05 11:39 PM


All times are GMT +1. The time now is 07:39 PM.

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

About Us

"It's about Microsoft Excel"