Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
I keep receiving ..... Can't find project or library on the following
line. If Left$(UCase$(response), 1) = "D" Then This macro works fine on other computers and had been working fine until recently. What is missing on this computer? TIA Gerry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
Open excel on the troublesome pc
Open your workbook Go into the VBE Select your project Tools|References Look for MISSING reference. Uncheck that missing reference. The missing reference may not (usually doesn't) have anything to do with the line that caused the error. If you're not using that reference, you can go back to your pc and remove it and then redistribute the workbook. If you're using that reference, you'll have more work to do for the troublesome pc's. Gerry wrote: I keep receiving ..... Can't find project or library on the following line. If Left$(UCase$(response), 1) = "D" Then This macro works fine on other computers and had been working fine until recently. What is missing on this computer? TIA Gerry -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
Take a look at this:
http://www.cpearson.com/excel/References.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Dave Peterson" wrote: Open excel on the troublesome pc Open your workbook Go into the VBE Select your project Tools|References Look for MISSING reference. Uncheck that missing reference. The missing reference may not (usually doesn't) have anything to do with the line that caused the error. If you're not using that reference, you can go back to your pc and remove it and then redistribute the workbook. If you're using that reference, you'll have more work to do for the troublesome pc's. Gerry wrote: I keep receiving ..... Can't find project or library on the following line. If Left$(UCase$(response), 1) = "D" Then This macro works fine on other computers and had been working fine until recently. What is missing on this computer? TIA Gerry -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't find project or library
On Aug 12, 12:07*pm, Dave Peterson wrote:
Open excel on the troublesome pc Open your workbook Go into the VBE Select your project Tools|References Look for MISSING reference. Uncheck that missing reference. * The missing reference may not (usually doesn't) have anything to do with the line that caused the error. If you're not using that reference, you can go back to your pc and remove it and then redistribute the workbook. If you're using that reference, you'll have more work to do for the troublesome pc's. Gerry wrote: I keep receiving ..... Can't find project or library on the following line. If Left$(UCase$(response), 1) = "D" Then This macro works fine on other computers and had been working fine until recently. *What is missing on this computer? TIA Gerry -- Dave Peterson Thanks Dave, that did the trick!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't find project or library | Excel Programming | |||
VBA - Cannot find project or library | Excel Programming | |||
Can't find project of library | Excel Discussion (Misc queries) | |||
Can't find project or library | Excel Programming | |||
Can't find project or library | Excel Programming |