Automation Error Unspecified Error Excel Visual Basic
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 automation error unspecified error excel 2007 site About Us Learn more about Stack Overflow the company Business Learn automation error unspecified error vba excel more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Automation Error Excel
Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up What
Automation Error Vb6
is causing “Automation error Unspecified error” on Worksheet_Activate? up vote 2 down vote favorite 2 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 vba automation error the object has disconnected from its client 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 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
One games Xbox 360 games PC
Excel Vba Automation Error Exception Occurred
games Windows games Windows phone games Entertainment All run time error automation error Entertainment Movies & TV Music Business & Education Business Students & run-time error '-2147 automation error vba educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate Internet 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 Band Microsoft https://support.microsoft.com/en-us/kb/134835 Lumia All 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
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Automation Error; Unspecified Error To get replies by our http://www.excelforum.com/showthread.php?t=856532 experts at nominal charges, follow this link to buy points and post http://www.vbforums.com/showthread.php?591505-RESOLVED-Run-time-error-%91-2147467259-(80004005)%92 your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 3 of 3 Automation Error; Unspecified Error Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good automation error Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-29-2012,10:03 AM #1 jprisco View Profile View Forum Posts Registered User Join Date 08-29-2012 Location Oswego, NY MS-Off Ver Office 2007 Posts 1 Automation Error; Unspecified Error I am havign issues with multiple users on Excel 2007. There may have automation error unspecified been a recent update that is causing these issues. All of them are getting an error either when opening Excel or when working on VBA: Microsoft Visual Basic --------------------- Automation error Unspecified error One of my users cannot save files either; it throws an error that unfortunately I have not written down. Has anyone seen similar behavior and can point me in the right direction? Register To Reply 08-29-2012,10:30 AM #2 Kyle123 View Profile View Forum Posts Visit Homepage Forum Guru Join Date 03-10-2010 Location Leeds MS-Off Ver 2013 Win7 Posts 5,869 Re: Automation Error; Unspecified Error Give these tips a try: http://www.cpearson.com/excel/StartupErrors.aspx Register To Reply 08-30-2012,12:52 PM #3 GregMiliates View Profile View Forum Posts Registered User Join Date 08-30-2012 Location New Mexico MS-Off Ver Excel 2007 Posts 1 Re: Automation Error; Unspecified Error I ran into this problem, and after spending a couple frustrating hours on it (!), found the cause and the fix. Turns out you need to un-register and re-register the mscomctl.ocx file. Here's some additional info:http://stackoverflow.com/questions/1...aused-by-forms http://social.technet.microsoft.com/
(80004005)’: 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 7 of 7 Thread: [RESOLVED] Run-time error ‘-2147467259 (80004005)’: Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Nov 11th, 2009,04:08 PM #1 Prod1 View Profile View Forum Posts Thread Starter New Member Join Date Nov 2009 Posts 5 [RESOLVED] Run-time error ‘-2147467259 (80004005)’: Hello all, I have a very basic application ('Console') in VB6 which launches various documents and shortcuts. All works fine with Office 2003, but on an Office 2007 machine, when I click on the button to launch an Excel document (in an IE window, as it happens) the document opens fine, but I also get this error: Run-time error ‘-2147467259 (80004005)': Automation error Unspecified error When that message is okayed the application ('Console') closes down. It's the same with all buttons which launch an Office document. The existing code on the button is this: Private Sub CommandButton65_Click() Dim Browser As Object Set Browser = CreateObject("InternetExplorer.Application") With Browser .Navigate ("\\eh-app-d14\SHAREDDATA\Service Desk\SHIFTS\2009\SDSK Shift Rota 2009.xls") .StatusBar = True .Toolbar = True .TheaterMode = False .Visible = True .Resizable = True .AddressBar = True End With End Sub I know that's really basic, but it's fine for what I want. Is there anyway to improve/amend the above code so that I do not get this Run-time error with Office 2007 PCs? Thanks. Last edited by Prod1; Nov 11th, 2009 at 04:09 PM. Reason: spelling Reply With Quote Nov 11th, 2009,04:32 PM #2 emartinho View Profile View Forum Posts Addicted Member Join Date Apr 2009 Location Toronto, Ontario Posts 242 Re: Run-time error ‘-2147467259 (80004005)’: Welcome to the board, I used your code to open a simple data only workbook in Excel 2007 and it worked fine. Is there any code in the your Excel file in the Workbook_Open event for example? That might be the place to look. Hope this helps. -EM --- REMEMBER: If your