PDA

View Full Version : Solved: Error on opening workbook on another computer.



Nocturne
10-18-2007, 12:11 PM
I have a vba project thta was written using excel 2003. My trouble is it is for an office and it will be used by other office members. All but one can open the workbook while the other can open it, it gives an error that the object doesn't exist on this machine. All are excel 2003 and all are version 11. When you open the vba the error goes to the date object. Can anyone help on this matter?

lucas
10-18-2007, 02:45 PM
Is the object a calendar control?

In the VBIDE, go to Tools>References, and see if there are any items with MISSING besides them. If they are, uncheck them

if it is the calendar control then see this thread:
http://www.vbaexpress.com/forum/showthread.php?t=10914

read the whole thread for a solution.....

Bob Phillips
10-18-2007, 02:46 PM
Sounds like he has a missing library.

In the VBIDE, goto Tools>References, and if any items are preceded by MISSING, unchcek it.