ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can't find project or library (https://www.excelbanter.com/excel-worksheet-functions/146646-cant-find-project-library.html)

AnnapolisStar

Can't find project or library
 
I wrote an application on my laptop and brought it over to my desktop where I
get the message "Can't find project or library" for all variables without
specific dim declarations and for the string function Right. The string
function InStr works ok.

When I simply copy the code module and insert it in a new workbook on my
desktop it works OK (in the new workbook).


Bob Phillips

Can't find project or library
 
In the VBIDE, goto ToolsReferences, and uncheck the item that has MISSING
in the text.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"AnnapolisStar" wrote in message
...
I wrote an application on my laptop and brought it over to my desktop where
I
get the message "Can't find project or library" for all variables without
specific dim declarations and for the string function Right. The string
function InStr works ok.

When I simply copy the code module and insert it in a new workbook on my
desktop it works OK (in the new workbook).





All times are GMT +1. The time now is 12:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com