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: [email protected]