Microsoft Excel 2003 Automation Error Unspecified Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 16:12:58 GMT by s_wx1011 (squid/3.5.20)
Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites Add-in Collections Productivity Suite Accounting Collection Business
Vba Automation Error Unspecified Error Internet Explorer
Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis excel vba automation error catastrophic failure Collection Time Saving Collection Software Download information Download purchased software Add-in improvements and upgrades Trial verisions Support runtime error automation error unspecified error Support How to contact us Top support questions What to do if add-in tabs or buttons do not appear Money back guarantee Ordering FAQ's Product FAQ's How to http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000 open and use our add-ins How to repair Microsoft Excel COM add-ins and why and how to remove How to stop Microsoft Excel From crashing Need more help? Let us connect computers Resources Excel problems solved by our add-Ins Excel and PC tips Excel and Office newsletters Excel and Office user groups Excel and Office training https://www.add-ins.com/support/automation_error.htm Links to other Excel sites Excel operating problems and solutions Company About Add-ins.com LLC How to contact us Policies Affiliate program License agreement View Cart Quantity Discounts Money back guarantee What to do if you get the message "Automation Error" If you get the message "automation error" when you open Excel after installing or when you click on the icon to open the add-in, the problem is caused by a problem with the installation of Microsoft Office. There is not a problem with the add-ins. Re-installing our add-ins does not solve. The problem is often caused by un-installing a trial version of Excel 2007, a missing service pack or an Office patch that was automatically run by Windows. It is sometimes caused by getting Office pre-installed on the PC when you purchase the PC. Please follow the instructions on our page on how to repair Office to solve. Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's Do
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros Automation Error; Unspecified Error To get replies by our experts at nominal http://www.excelforum.com/showthread.php?t=856532 charges, follow this link to buy points and post your thread http://www.vbforums.com/showthread.php?591505-RESOLVED-Run-time-error-%91-2147467259-(80004005)%92 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 Average Bad automation error 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 been a recent update that is causing automation error unspecified 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/...0-c166aad4ff19 Register To Reply + Reply to Thread « Previous Thread | Next Thr
(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 issue is resolved, use the Thread Tools menu to set it as such, and be sure to rate the posts that help you the most! Just because