Compile Error Cannot Find Project Or Library Format
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss compile error cannot find project or library excel 2010 the workings and policies of this site About Us Learn more about compile error cannot find project or library excel 2013 Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow java compile error cannot find symbol Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each
Can't Find Project Or Library Excel 2013
other. Join them; it only takes a minute: Sign up “Can't find Project or Library” for standard VBA functions up vote 36 down vote favorite 11 So I'm having to run someone else's excel app on my PC, and I'm getting "Can't find Project or Library" on standard functions such as date, format, hex, mid, etc. Some research can't find project or library excel 2016 indicates that if I prefix these functions with "VBA." as in "VBA.Date" then it'll work fine. Webpages suggest it has to do with my project references on my system, whereas they must be ok on the developer's system. I'm going to be dealing with this for some time from others, and will be distributing these applications to many others, so I need to understand what's wrong with my excel setup that I need to fix, or what needs to be changed in the xls file so that it'll run on a variety of systems. I'd like to avoid making everyone use "VBA." as an explicit reference, but if there's no ideal solution I suppose that's what we'll have to do. How do I make "VBA." implicit in my project properties/references/etc? vba excel-vba namespaces reference share|improve this question edited Jun 29 '12 at 17:57 JimmyPena 5,97932844 asked Feb 3 '09 at 14:05 Adam Davis 59k42210303 are you developing in one version of excel and distributing to users using a different version? &ndash
360 games PC games excel can't find project or library crash Windows games Windows phone games Entertainment All Entertainment
Can't Find Project Or Library Access 2013
Movies & TV Music Business & Education Business Students & educators
Compile Error Can't Find Project Or Library Access 2007
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/507191/cant-find-project-or-library-for-standard-vba-functions Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/840926 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
Forums Excel Questions Can't find project or library error on Format function Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 12 Can't find project or library error on Format functionThis is http://www.mrexcel.com/forum/excel-questions/693346-cant-find-project-library-error-format-function.html a discussion on Can't find project or library error on Format function within the Excel Questions forums, part of the Question Forums category; Hi, I have this code in a macro and it works on my laptop. Code: Randomize c = Format(rnd(1), "#0.00") ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch find project to Hybrid Mode Switch to Threaded Mode Mar 25th, 2013,07:43 AM #1 abberyfarm Board Regular Join Date Aug 2011 Posts 733 Can't find project or library error on Format function Hi, I have this code in a macro and it works on my laptop. Code: Randomize c = Format(rnd(1), "#0.00") c = Round(rnd, 2) However, when I try run it on my desktop I get an error 'Can't find project or library' with find project or the 'Format' word highlighted. Could anybody tell me how to find out which library is missing and how I activate it? Thank you also posted here http://www.ozgrid.com/forum/showthre...767#post655767 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 25th, 2013,07:56 AM #2 VoG MrExcel MVP Join Date Jun 2002 Location 127.0.0.1 Posts 63,652 Re: Can't find project or library error on Format function Check for missing references Missing References In VBA Share Share this post on Digg Del.icio.us Technorati Twitter HTH, Peter Please test any code on a copy of your workbook. Reply With Quote Mar 25th, 2013,08:32 AM #3 abberyfarm Board Regular Join Date Aug 2011 Posts 733 Re: Can't find project or library error on Format function Hello, I followed the instructions on that page and cannot find a missing reference, you wouldn't by any chance know which reference this function belongs to and what I should be looking for? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Mar 25th, 2013,08:36 AM #4 RoryA MrExcel MVPModerator Join Date May 2008 Location East Sussex Posts 28,295 Re: Can't find project or library error on Format function You have to check it on the desktop machine, not the laptop, with that workbook active and you are looking for any checked