excel vba compile error object library invalid Corpus Christi Texas

Address 400 Mann St, Corpus Christi, TX 78401
Phone (361) 884-8151
Website Link http://www.emk3.com
Hours

excel vba compile error object library invalid Corpus Christi, Texas

It worked on one machine but not another. All activeX and macro's have been enabled without prompts. share|improve this answer answered Jan 21 '13 at 17:18 Hillyman 111 add a comment| up vote 1 down vote Try to delete startup addins from here (mind Office version): C:\Program Files\Microsoft Check for cached *.exd files Search for all files (including hidden files) with the extension *.exd. (By default, Windows does not search for hidden files, so you must change that setting to

Click on DebugCompile VBAProject to verify that the problem is solved 10. Open (if they are not already open) one of the modules or code behind forms 4. Click "Help" for information on how to correct this error. Should I just let my subscription run out and purchase another version?

The VBA works fine on my PC, but not on the PC that I want to use for a demo machine. Open (if they are not already open) one of the modules or code behind forms 4. All rights reserved. Just tried running same SS on my son's laptop which is running Office 2013 and it opens, but does not like "AppActivate" in the code!

Thanks for helping make community forums a great place. Click the link to create a password, then come back here and sign in. Excel_ref.png Register To Reply 12-31-2014,09:08 AM #9 romperstomper View Profile View Forum Posts Visit Homepage Forum Guru Join Date 11-04-2008 Location A1 MS-Off Ver Most Posts 12,299 Re: Object library invalid You said that “application runs well on other computers”, what the version of office that these machines installed?

Yours finally resolved the issue. Go into a command prompt and type the following DOS commands: Code: CD \Documents and Settings DEL /S /A:H /A:-H *.EXD share|improve this answer answered Jan 20 '11 at 0:18 Archer Before clicking the shape and opening the form I tried to reference the MSCOMCT2.ocx library dinamically with the following code. It works for Excel 2007 on Windows XP professional.

I'm at a loss with it and need some extra help. We want to get this message out to the most people possible.

Tags News VBA Comments (59) Cancel reply Name * Email * Website Denis says: June 11, 2010 at 6:31 Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search Re the .exd files, how many did you delete?

of the underlying objects, and they are the same as well. Should I just let my subscription run out and purchase another version? This error commonly occures when code is incompatible with the version, platform, or architecture of this applications. This fixed the problem in my case.

With it I have done extensive work in VBA Excel on my laptop and so have the family members I share it with on theirs. The error message is the same as in the original posting. share|improve this answer answered Mar 19 '15 at 13:57 Char2d2 814 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign Thanks Reply Excellent Abbas Mohamed..

Applications run well on other computers. >> Compile error: Object library invalid or contains references to object definitions that could not be found According to the error message, it seems some Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Regard, Jaime Friday, January 30, 2015 7:21 PM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. Did you try registering the ocx?

I hope this could help to someone. In your client machine or other way? Excel 2007 on Windows XP. Hopefully that is not the reason that something I've used in vba only works in the PRO version of Excel?

Click on Tools / References… 5. http://excelmatters.com/2014/12/10/o...ivex-controls/ Register To Reply + Reply to Thread Page 1 of 2 1 2 Last Jump to page: « Previous Thread | Next Thread » Thread Information Users Browsing this Thread Reply KB says: April 20, 2012 at 12:22 am you are a STAR Abbas Mohamed..it works like a charm Reply Celestique says: April 20, 2012 at 5:12 am Linus: Perfect! This article was helpful (thinking…) · Flag this article as inaccurate…Flag this article as inaccurate… · Admin → New and returning users may sign in Sign in prestine Your name

Go into a command prompt and type the following DOS commands: VB: > CD \Document And Settings > DEL /S /A:H /A:-H *.EXD That is what worked for me. If there is no error, this is not necessarily an indication of a clean bill of health, as there are other ActiveX controls which may have problems. Open (if they are not already open) one of the modules or code behind forms 4. Open the command prompt. 2.

Open a command prompt as Administrator and enter this command: msiexec /a /qb TARGETDIR=C:\Temp (mscomctl.ocx will now be found in C:\Temp\Windows\System32 or one of its subfolders) Unregister the old file. This same spreadsheet works fine on the desktop computer! Open the command prompt. 2. Reply Nalin says: April 29, 2012 at 9:31 pm Thanks Abbas for your help ..

Register To Reply 12-31-2014,02:38 AM #5 romperstomper View Profile View Forum Posts Visit Homepage Forum Guru Join Date 11-04-2008 Location A1 MS-Off Ver Most Posts 12,299 Re: Object library invalid or This article was helpful (thinking…) · Flag this article as inaccurate…Flag this article as inaccurate… · Admin → New and returning users may sign in Sign in prestine Your name Click Open and the reference will appear as Microsoft Windows Common Controls 6.0 (SP6) 9. The code just adds a textbox if they do not have the correct reference.

thanks for your help…. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote April 18th, 2006 #2 cgilker View Profile View Forum Posts I agreed to these rules Join Date 15th April 2006 Posts invalid email (thinking…) Reset or sign in with UserVoice password Forgot password? Reply Ranjit says: June 5, 2012 at 11:21 pm Worked Abbas steps for me in Windows XP with Office 2007 Thanks Abbas Reply Prabhakar says: June 14, 2012 at 3:17 am

Thanks. –Josh Brown May 15 '12 at 18:51 C:\Documents and Settings>DEL /S /A:H /A:-H *.EXD Deleted file - C:\Documents and Settings*****\Application Data\Microsoft\Forms \MSComctlLib.exd Deleted file - C:\Documents and Settings****\Local They can be the source of VBA errors, particularly when the runtime files are updated through Microsoft patches.