View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Can't find project or library

Make sure the error occurs before you look in references for a MISSING
reference. You may have to hit reset before it lets you in refernces.
Also, make sure the problematic workbook is the active project (selected in
the project explorer) when you look. Just because a workbook is the active
workbook in Excel, doesn't mean it is the active project in the VB editor
(VBE).

Make sure you never have references to anything but the default objects in
Excel

Excel, vba, msforms 2.0, office, OLE automation

Tell your Dad to clean out his Temp directory as well.

--
Regards,
Tom Ogilvy

"Jennifer" wrote in message
...
I have looked at previous answers to this question but i need it explained
a
little further please.
I created a workbook in Excel '03 and sent it to my Dad. He also has
Office
2003, so why does he get the error: Can't find project or library when
trying
to run the the workbook. I have gotten on his computer and in VBA gone to
TOOLS References but i don't seeing anywere that has "Missing" attached
to
it. And i don't know where else to look. The following are lines i am
having
trouble with

<<< txtDate3.Value = Format(Me.txtDate3, "")

<<< txtPriceLB.Value = Format(Me.txtPriceLB.Value, "$#,###,###.00")

Since this works with no problems on my computer; how do you suggest i
know
in advance what will work on my dads computer. He is getting frustrated
with
me when we run into these little glitches. Thank you in advance.
--
Thank you,

Jennifer