Can't find project or library

[Jennifer]

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.

 

[RichardSchollar]

Hi Jennifer

I have a feeling (may be wrong here, so apologies if I'm leading you up
the garden path so-to-speak) that Excel may be getting confused with
the Format command. Try preceding it with VBA ie:

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

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

Give it a try and see if it changes anything.

Richard

 

[JLGWhiz]

It is probably looking for an Office 95 or earlier library since you used the
Me term. I think I read somewhere that you should avoid using Me in W2003
for the reason you are encountering.

 

[Chip Pearson]

I think I read somewhere that you should avoid using Me in W2003
for the reason you are encountering.

Then what you read was wrong. The 'Me' keyword, which always refers to the
object containing it, is perfectly valid in any version of VB/VBA that
supports it. Indeed, there are some things that can not be done
(efficiently) without it.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Tom Ogilvy]

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.