LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 201
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile error: Can't find project or library Melanie New Users to Excel 14 August 21st 09 02:54 AM
Compile error: Can't find project or library Fred Excel Programming 3 April 18th 06 08:59 AM
Compile error: Can't find project or library Vince Excel Programming 2 October 13th 05 04:50 PM
Compile error: Can't find project or library Daniel[_17_] Excel Programming 3 December 8th 04 01:05 PM
Compile Error! Can't find project or Library --- Help! Suh Suk Ho Excel Programming 2 July 21st 03 08:26 PM


All times are GMT +1. The time now is 04:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"