UCase causes "Unable to open project or library" error
I've written this code to cause all data to be set to uppercase on one of the worksheets in my workbook. The code is located on Sheet2 which is called "Data". I can run it just fine on my machine, but someone else running on their machine causes it to error out with "Unable to open project or library". What have I done wrong? I'm very new to this and really don't know what I'm doing.
Please Login or Register to view this content.
Last edited by Leith Ross; 03-08-2011 at 05:36 PM. Reason: Added Code Tags
Hi there,
The fact that it works on your computer but not on others makes me suspect that there's a missing Reference on the other computers.
On the "problem" computers, open the Visual Basic Editor (Alt + F11) and select Tools > References.
Scroll down through the list of "ticked" References and see if any of them is/are prefixed with the word "MISSING:" This indicates that a program (e.g. Outlook) which Excel needs (or "thinks" it needs) to access is unavailable on that computer.
If you know that the missing Reference (program) is actually not needed for your workbook, you can "untick" the Reference, save the workbook, and everything should be ok. If you know that the missing Reference IS needed, you should install the missing program on that computer.
By the way, this error is often generated when a "problem" computer is running an earlier version of an application than the version installed on the computer where the workbook was created. In many cases all that is required is to "untick" the missing Reference, scroll down the list until you see whatever version of that application is installed on the computer, "tick" it, and then click on "OK".
I hope this is of some help to you - please let me know how you get on.
Regards,
Greg M
In more recent time there are also issues with previously installed libraries no longer being available by default - OWC for ex.Originally Posted by Greg M
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Greg M - thanks! I will have my tech try that.
DonkeyOte - OWC? What is that? I'm still exceedingly new to this.
Office Web Components - just an example of something that is not installed from Office 2007 onwards but was with earlier versions.
Follow Greg M's advice in terms of analysis your References in VBE and report back with whatever is listed as MISSING
re: UCase causes "Unable to open project or library" error
That worked! Thank you both very much.
Hi again,
Many thanks for your feedback - glad to hear that things are now working correctly for you.
Regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks