Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
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 Jennifer wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
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. "Jennifer" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
"JLGWhiz" wrote in message
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) "JLGWhiz" wrote in message ... 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. "Jennifer" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find project or library | Excel Programming | |||
Cant find project or library | Excel Programming | |||
Can't find project or library | Excel Programming | |||
cant find project or library | Excel Programming | |||
Cant find project or library | Excel Programming |