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
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 ??
' 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.
'E-mail: [email protected]