Automation Error Unspecified Error Vba Excel 2007
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 01 Oct 2016 19:28:35 GMT by s_hv720 (squid/3.5.20)
One games Xbox 360 games PC excel vba automation error catastrophic failure 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://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/automation-errorunspecified-error/2c75ea54-981f-4634-ad25-f11647034000 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 experts at http://www.excelforum.com/showthread.php?t=856532 nominal charges, follow this link to buy points and post your https://www.add-ins.com/support/unspecified_error.htm 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 Average automation error 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 been a recent update vba automation error 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/...0-c166aad4ff19 Register To Reply + Reply to Thread «
Data add-ins Downloadable macro books Specialty add-ins Time Saving add-ins Our favorites Add-in Collections Productivity Suite Accounting Collection Business Analysis Collection Charting Collection Data Collection Macro Book Collection Risk Analysis Collection Time Saving Collection Software Download information Download purchased software Add-in improvements and upgrades Trial verisions Support 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 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 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 "Unspecified Error" If you get the message "Unspecified Error" when you open Excel or when you close excel after installing our add-ins, 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. Please follow the instructions on our page on how to repair Office to 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. If you have installed an add-in (not ours) or a macro enabled workbook and you get the message "Unspecified Error" there are two likely causes: A problem with the installation of Microsoft Office. The steps at how to repair Office may solve If the repair steps do not solve, the most likely cause is a DLL referenced in the add-in or macro enabled workbook that is not compatible with your version of Excel. Our add-ins do not use DLLs, so we avoid this issue. To determine if it is a DLL conflict, check Tools, References in the VBA editor for the add-in or macro workbook. Most likely there is a control on a form that requires a special DLL reference. Remove this control, and the reference will disappear. If this eliminates the error (after commenting out any code that may refer to the control you removed), then the problem is the DLL. If the original code works on some machines and not on others, then the machines on which i