Automation Error Unspecified
Contents |
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 automation error unspecified error excel Overflow the company Business Learn more about hiring developers or posting ads with us automation error unspecified error 80004005 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community automation error unspecified error 2147467259 of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What is causing “Automation error Unspecified error” on Worksheet_Activate? up vote 2 down vote favorite 2
Automation Error Unspecified Error In Vba
I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I regularly have workbooks open that have too many calculations in the for me to have auto-calculation on. So I have auto-calc set to manual, and the following code in the worksheet: Private Sub Worksheet_Activate() A_Dates.Calculate End Sub This microsoft visual basic automation error unspecified error has worked fine for the last 3 months, day-in and day-out. Yesterday, it stopped working. It now throws this error on the declaration line: Microsoft Visual Basic Automation error Unspecified error [OK] [Help] I have tried changing how I reference the sheet, using: Sheets("Dates").Calculate and ActiveSheet.Calculate to no avail. I've also included error handling: On Error Resume Next which doesn't prevent it. I've even gone so far as: Private Sub Worksheet_Activate() On Error GoTo headache Sheets("Dates").Calculate Exit Sub headache: Exit Sub End Sub and it still shows up. I am totally at a loss. Help? Additional Information I have the following references, and use all of them in various macros in this workbook: Visual Basic for Applications Microsoft Excel 12.0 Object Library OLE Automation Microsoft Office 12.0 Object Library Microsoft Scripting Runtime Microsoft Forms 2.0 Object Runtime Microsoft HTML Object Library Microsoft Internet Controls Microsoft ActiveX Data Objects 2.8 Library Microsoft ActiveX Data Objects Recordset 2.8 Library vba error-handling excel-2007 share|improve this question edited Sep 4 '12 at 21:43 asked Sep 4 '12 at 20:30 Farfromunique 1291112 If you comment that line out and manually force a Recalc (using [F9]) do you receive an error? –mwolfe02 Sep 4 '12 at 21:13 No, I do not. And, everything s
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 01 Oct 2016 18:44:29 GMT by s_hv902 (squid/3.5.20)
or outdated Difficult to follow Other Comments:(Max 1000 chars) Would you like a response? Email is required. http://www.vbforums.com/showthread.php?649774-Runtime-Error-quot-Automation-error-Unspecified-error-quot Email: KB00686 - Fixing "Automation Error" in Excel after applying MS12-060 Product: PI BatchView / PI automation error DataLink / PI Tag Configurator Version(s): Multiple Platform: Windows Issue If you have already applied the Microsoft patch MS12-060, you may see the error "Automation Error: Unspecified Error" or "System Error &H8000FFF (-2147418113). Catastrophic automation error unspecified failure" when starting Microsoft Excel. When closing Excel with PI DataLink enabled, you may also see the error "Compile error in hidden module: modAddin." Solution Typically, these errors can be resolved by searching for and deleting all *.exd files on the machine (including hidden files) as described in KB00804. In some cases, the fix for this problem is to re-register MSCOMCTL.OCX. To do this, follow the steps noted in the Microsoft article "Unspecified Automation Error" after applying MS12-060. Article ID: KB00686 Created: 2012-08-16 Article Type: How-To Last Updated: 2015-02-02 Enabling Operational Intelligence Privacy Legal Copyright Contact Us
Unspecified error " If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 1 of 1 Thread: Runtime Error "Automation error Unspecified error " Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 12th, 2011,09:44 PM #1 opor_ulen View Profile View Forum Posts Thread Starter New Member Join Date Feb 2011 Posts 5 Runtime Error "Automation error Unspecified error " Hello, I have many computer - Server : include database and vb program - Many Client : include database and web service Server and many client connect by LAN connection In vb program i have function to save data to database server and connect and send the data to web service in each client computer using SOAP methode. Then that web service work to save the data on database on client computer. When i running this program i get deferent result : - In first time i get nothing error - in other time i get error message : "WSDLReader:Loading of the WSDL file failed HRESULT=0x80070057 - WSDLReader:XML Parser failed at linenumber 0, lineposition 0, reason is: The download of the specified resource has failed. HRESULT=0x1 - in other time i get nothing error again - in other time i get error message : "Automation error Unspecified error " - in other time i get nothing error in partly client computer and get this error message in other partly client computer : "Err[031502]Cannot open database requested in login 'BenzineDITServer'. Login fails" - And now i get this error message in all client computer: "Automation error Unspecified error " so, what is the meaning of this error ? What can I do to resolve this problem ? Can you help me, please ? beforehand i say thanks. Reply With Quote Quick Navigation Visual Basic 6 and Earlier Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Visual Basic Visual Basic .NET VB.net CodeBank Visual Basic 6 and Earlier CodeBank - Visual Basic 6 and earlier Modern Windows Experience (Metro) Office Development Mobile Development ASP, VB Script Database Development Repo