| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error: Can't find project or library
I have been testing without any issues on one computer, when I ran my code on
another computer I got this error. What's more strange is that it is complaining about the LEFT command. If Dir(Left(MainPath, 3), vbDirectory) = "" Then just to test, I removed the LEFT statement: If Dir(MainPath, vbDirectory) = "" Then and it worked fine, but stopped on the next LEFT. If Len(MainPath) = 3 Then MainPath = Left(MainPath, 2) Any ideas? -- Trefor |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error: Can't find project or library
Ok, more research and I founf the a MISSING reference for "Microsoft Outlook
11.0 Object library" Why would this affect the Left command? Why would this be missing on another computer? How do I fix this? -- Trefor "Trefor" wrote: I have been testing without any issues on one computer, when I ran my code on another computer I got this error. What's more strange is that it is complaining about the LEFT command. If Dir(Left(MainPath, 3), vbDirectory) = "" Then just to test, I removed the LEFT statement: If Dir(MainPath, vbDirectory) = "" Then and it worked fine, but stopped on the next LEFT. If Len(MainPath) = 3 Then MainPath = Left(MainPath, 2) Any ideas? -- Trefor |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compile error: Can't find project or library
Remove the reference or fix it using the browse button in the references
dialog. -- Regards, Tom Ogilvy "Trefor" wrote: Ok, more research and I founf the a MISSING reference for "Microsoft Outlook 11.0 Object library" Why would this affect the Left command? Why would this be missing on another computer? How do I fix this? -- Trefor "Trefor" wrote: I have been testing without any issues on one computer, when I ran my code on another computer I got this error. What's more strange is that it is complaining about the LEFT command. If Dir(Left(MainPath, 3), vbDirectory) = "" Then just to test, I removed the LEFT statement: If Dir(MainPath, vbDirectory) = "" Then and it worked fine, but stopped on the next LEFT. If Len(MainPath) = 3 Then MainPath = Left(MainPath, 2) Any ideas? -- Trefor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile error: Can't find project or library | New Users to Excel | |||
| Compile error: Can't find project or library | Excel Programming | |||
| Compile error: Can't find project or library | Excel Programming | |||
| Compile error: Can't find project or library | Excel Programming | |||
| Compile Error! Can't find project or Library --- Help! | Excel Programming | |||
Hybrid Mode
