Share it with others Like this thread? ClassFactory cannot supply requested class Article ID: KB00804 Created: 2013-06-14 Article Type: Informational Last Updated: 2016-02-10 Enabling Operational Intelligence Privacy Legal Copyright Contact Us Register Help Remember Me? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jun 20th, 2012,01:34 PM #16 snb_ Board Regular Join Date Nov 2009 Posts 561 Re: System Error &H80040111(-2147221231). So not only can solve the problem by installing the previous version again? his comment is here
Register the new mscomctl.ocx. Thanks again. All rights reserved Register Help Remember Me? Peter Thornton Wednesday, March 13, 2013 5:06 PM Reply | Quote Moderator 0 Sign in to vote Peter, Thank you for reply. https://social.msdn.microsoft.com/Forums/en-US/e8c8d646-125d-49bf-a9f6-dcf873406b02/excel-vba-error-classfactory-cannot-supply-requested-class?forum=isvvba
I have unregistered both libraries with REGSRV32 and replaced them with: MSCOMCTL.OCX: 22.214.171.124 -> 126.96.36.199 COMCTL32.OCX: 188.8.131.52 -> 184.108.40.206 and then re-registered them. But whatever - it fixed my problem! What have you done to use the listview again? This is a standard Excel Addin.
If you don't have direct access to the target machine, send a dummy file and attempt to add all the requisite references programmatically. I cannot check the Tools/References to see if he is missing a reference because it is greyed out. Yes No Partially Tell Us More: Select This content appears incomplete The content appears incorrect or outdated Difficult to follow Other Comments:(Max 1000 chars) Would you like a response? Email: KB00804 - VBA Errors in Microsoft Excel Product: PI BatchView / PI DataLink / PI Tag Configurator Version(s): All Platform: Windows English German Spanish French Japanese Korean Portuguese (Brazilian) Russian
If the above does not work please try the following: 1.) Make sure no Excel is running on the machine. . 2.) Delete FORMS and EXCEL folders under C:\Documents and Settings\Your This repeats about four times and then he can exit the editor. To start viewing messages, select the forum that you want to visit from the selection below. Solution These errors are often related to a malfunctioning Microsoft ActiveX control used by an add-in, or by old cached VBA files. The following steps may help to resolve this issue.
From Windows Explorer, navigate to the following folder and delete the files that have a .EXD extension: C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Forms\ 5. When using Windows XP, use a file manager like Windows Explorer to go into the user specific directory "%AppData%\Microsoft\Forms\" and delete the EXD files "RefEdit.exd" and "MSComctlLib.exd", then restart TM1 Perspectives. Solved! Class Factory cannot supply requested Class, Out of Memory Hi Andrew, Yes i did, but no hope.
Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Homepage Sign up now! you'll see what Office is trying to read from the registry when it throws the error). See the answer in context. 0 Kudos Solved the problem (Finally!)Downloaded the VB6 Update from Microsoft, extracted MSCOMCTL.OCX and MSCOMCT2.OCX copied them to C:\Windows\SysWow64 then registered them with regsvr32.
Open Perspectives. http://sonoportal.net/classfactory-cannot/classfactory-cannot-supply-class.html These are temp files of object libraries that Office creates during installations and updates and can mess up things in VBA. Reply With Quote Dec 15th, 2010,08:06 PM #2 dilettante View Profile View Forum Posts PowerPoster Join Date Feb 2006 Posts 15,421 Re: problems with mscomctl.ocx (ClassFactory cannot supply requested class) Good Note: all 3 attempts are buggy and should not be installed.
Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not From that i understand that the problem is not in DLL component it's with some issue in Excel. Friday, March 15, 2013 1:13 PM Reply | Quote 0 Sign in to vote Some dlls have different GUIDs with subsequent versions, which means different versions can be referenced with the weblink Run a repair of Microsoft Office from Add\Remove Programs 3.
PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick Wednesday, March 13, 2013 8:44 PM Reply | Quote 0 Sign in to vote Peter, It took a while for user to get back to me.... Class Factory cannot supply requested Class, Out of Memory within the Excel Questions forums, part of the Question Forums category; Hi Andrew, i am using Spreadsheet component in my project. ClassFactory cannot supply requested class How can I get it to register?
The file is on the computer, but maybe in the wrong Program File folder. Reply With Quote Quick Navigation Excel Help Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Announcements Announcements Introductions VBA Code & Other Help How to Even i got my IT troubleshooting team to fix the issue. check over here It works fine on most computers.
Typically the problem is more likely to occur if the reference had been saved in the Win64bit SysWOW32 folder and reopened in Win32bit, but no doubt the problem may occur in To repairMicrosoft Office explicitly, openthe Control Panel and choose Programs and Features (Add or Remove Programs inolder versions of Windows). Open a command prompt as Administrator and enter this command: msiexec /a
I don't think so there will be some issue with my coding. You’ll be auto redirected in 1 second. Wednesday, March 20, 2013 8:45 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
© Copyright 2017 sonoportal.net. All rights reserved.