Excel System Error Microsoft Visual Basic
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 10:28:41 GMT by s_wx1131 (squid/3.5.20)
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more ms access visual basic about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
Ms Word Visual Basic
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each ms outlook visual basic other. Join them; it only takes a minute: Sign up Excel giving “System Error &H80004005 (-2147467259). Unspecified error” message up vote 1 down vote favorite 1 Everytime I load up my Excel document, it repeatedly shows up with the http://answers.microsoft.com/en-us/windows/forum/windows_xp-windows_programs/solved-system-error-h80004005-214767259/828e9d6f-cc50-46ab-b283-480b8908c6e0 message from the title. The two options are OK and Help. help opens Office Help which is useless for anything. Clicking OK displays another message saying "Compile error: Out of memory." with OK and Help buttons. Clicking OK brings up VBEditor with no debug line selected and no macro popped up either for that matter. Eventually, after it repeats that and complains 20 (exaggeration) more times (I think that's due to having a lot of duplicate code http://stackoverflow.com/questions/30539623/excel-giving-system-error-h80004005-2147467259-unspecified-error-message for ActiveX controls on each sheet). It highlights the first line (the Sub declaration) of the code below. Private Sub ComboBox4_Change() Range("B3") = ActiveSheet.ComboBox4.text End Sub Now this is dealing with an ActiveX ComboBox. Opening a file from an earlier date will give no errors. It's like after a certain date, it just refuses to work with it. And get this, it's only happening on one computer. The files are saved on a network drive, which shouldn't be causing an error. excel vba excel-vba activex system-error share|improve this question asked May 29 '15 at 21:50 icebird76 146116 A Shot in the dark: is Comctl32.dll registered on your machine? –Siddharth Rout May 29 '15 at 21:56 I used "RegSvr32 comctl32.dll" in the Run window and it gave an error saying that it was loaded, but the entry-point DllRegisterService was not found. –icebird76 May 29 '15 at 22:06 yes. you have to register it using Admin rights :) –Siddharth Rout May 29 '15 at 22:08 Extract the comdlg32.ocx to your the Windows\System32 folder or Windows\SysWOW64. Then right click on CMD->Run as administrator and then register from there –Siddharth Rout May 29 '15 at 22:11 2 There was also this problem last December. With Excel closed, delete the following files del %temp%\vbe\*.exd del %temp%\excel8.0\*.exd del %appdata%\microsoft\forms\*.exd del %appdata%\microsoft\local\*.exd –ChipsLetten May 29 '15 at 22:19
from 8hAM to 12hPM PDT. During that time, you will not be able to view or create cases online. If you need any assistance, you can either email, or call us at https://techsupport.osisoft.com/troubleshooting/kb/kb00804 one of our office locations. Did this help you? 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 is required. Email: KB00804 - VBA Errors in Microsoft Excel Product: PI BatchView / PI DataLink / PI Tag Configurator Version(s): All Platform: Windows visual basic English German Spanish French Japanese Korean Portuguese (Brazilian) Russian Chinese (Simplified) Issue As you use Microsoft Excel with one or more PI add-ins enabled (PI DataLink, PI Tag Configurator, or PI BatchView for Excel), you may encounter one of the Microsoft Visual Basic for Applications errors below. You may also see these errors when you open Microsoft Excel or use certain functions within the excel visual basic add-ins, such as the Insert Trend function in PI DataLink. Could not load an object because it is not available on this machine Compile error in hidden module: modAddin Compile error in hidden module: Main Object library invalid or contains references to object definitions that could not be found Run-time error ‘459’: Object or class does not support the set of events System Error &H80040111 (-2147221231). ClassFactory cannot supply requested class PI Excel add-ins make use of certain Microsoft-provided ActiveX controls. When there are problems with these controls, add-ins which use these controls will encounter them and produce errors. These error messages may also be caused by the Microsoft security patches, such as MS12-060. See KB00686for more information. 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. Verify required prerequisites and settings Make sure that the add-ins and related items are installed properly. For example, if the PI SDK is not installed, that will affect many of the PI add-ins. Confirmthat the ActiveX controls are enabled (not disabled). In