Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
| Search | Today's Posts | Mark Forums Read
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 21st, 2005, 11:49 AM
Registered User
 
Join Date: Oct 2005
Location: Oslo, Oslo, Norway.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Solution Excel's can't find the project or library

Simple Solution for the infamous "can't find the project or library" Error

1 start Microsoft Excel.exe
2 open the Visual Basic Editer
3 test the following first ! put some txt in A1 "this is a Test ??"
4 check the value by placing your mouse pointer over the variables ( S n ) etc


Sub TestBasicLib()
Dim s, n, i, k
    s = Cells(1, 1) '"this is .....??"get the text in the string (s)
    s = UCase(Cells(1, 1)) '"This...??" No ERRor so far ??
    n = Mid(s, 4, 1) 'n="S" ?? No ERRor so far ??
End Sub
' If no errors jour lib's are Ok and every thing should work fine !
Rem if it runs every thing is fine export your modules and sheets if needet
Rem Import Modules and sheets

'It should work fine now "phew at last !!!"

' Ok now export you modules form your program.
' If needet your Sheets "I did"
open excel.exe load your proram/sheets (*.xls) again and import you'r modules ???.bas files
' move your sheets over to the new excel "Just drag & Drop"
'export your modules close the eronius progam/sheets and import the modules into the new one it should work fine now

' Greetings 2Y all
'Paul J Moesman.
'Oslo Norway.
'E-mail: paul@moesman.no






Similar Threads
Thread Thread Starter Forum Replies Last Post
compile error: can't find project or library bruty Excel VBA 1 August 2nd, 2007 06:12 AM
Can't Find Project Or Library jonny10 Excel VBA 1 November 30th, 2006 07:00 AM
Can't find Project or Library. dpkbahuguna Beginning VB 6 1 September 7th, 2006 07:18 PM
Left$ returns Can't Find Project or Library Ron Howerton Access VBA 7 March 22nd, 2006 11:22 AM
Compile error(Can't find project or library) shamala Excel VBA 1 February 21st, 2006 04:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.