Compile Error Automation Error
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 00:24:42 GMT by s_hv995 (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 automation error vba and policies of this site About Us Learn more about Stack Overflow
Automation Error Vb6
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags automation error the object invoked disconnected from its clients Users Badges Ask Question x 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 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/excel-2007-compile-error-automation-error-on/c4e0edaf-9a51-4fd6-8aa1-2bce1dd2b1da takes a minute: Sign up What 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 http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate 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 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
Way | Trading Add-ins For Excel | Convert Excel Into Calculating Web Pages Excel Web Pages | Produce Clean Efficient VBA Code Every Time | Build Automated Trading Models In Excel | Excel Web Pages | Excel Video Training Forum http://www.ozgrid.com/forum/showthread.php?t=179688 New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts What's New? Advanced https://www.experts-exchange.com/questions/27835960/Excel-2010-VBA-Automation-Error-Unspecified-Error.html Search Forum HELP FORUMS Excel General Compile Error:automation error in vba Excel Training / Excel Dashboards Reports 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 automation error visit from the selection below. If you don't like Google AdSense in the posts, register or log in above. Click here to view the relaunched Ozgrid newsletter. Results 1 to 10 of 10 Thread: Compile Error:automation error in vba Thread Tools Show Printable Version Search Thread Advanced Search June 18th, 2013 #1 ashu1990 View Profile View Forum Posts Established Member Join Date 11th June 2013 Location Mumbai,India Posts 369 Compile Error:automation error in vba Hi guys, i error automation error am stuck with an error where the macro work fines into my pc but tried to test into client pc it gave me an error Compile Error:automation error as i am running the macro inside a VM player (eg:- critix type) which are used here. nothing works as soon as i press the run button the error pops up. i tried searching it on others forums as well as this but didn't got the answer can any one state me the reason for this error.. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote June 18th, 2013 #2 cytop View Profile View Forum Posts . Join Date 1st September 2010 Posts 10,905 Re: Compile Error:automation error in vba The machine actually running the code does not have some component(s) installed. That's all that can be said based on the information you have supplied. Excel Video Tutorials / Excel Dashboards Reports Reply With Quote June 18th, 2013 #3 ashu1990 View Profile View Forum Posts Established Member Join Date 11th June 2013 Location Mumbai,India Posts 369 Re: Compile Error:automation error in vba Originally Posted by cytop The machine actually running the code does not have some component(s) installed. That's all that can be said based on the information you have supplied. Thanks for the reply cytop.. I checked the refrences and did not found any missing refrences can you tell me what are
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Excel 2010 VBA - Automation Error - Unspecified Error Want to Advertise Here? Solved Excel 2010 VBA - Automation Error - Unspecified Error Posted on 2012-08-20 MS Applications MS Office MS Excel 1 Verified Solution 7 Comments 6,095 Views Last Modified: 2012-08-21 Hello, I have a spreadsheet with some code in it, but when i try to launch one of the forms I get the error: Compile Error: Automation Error Unspecified Error The error doesn't go to any specific piece of code to give me any hints as to what the actual problem might be. Then - I view one of the forms I have built in. When i right click on the form and select "View Code" I get the error; Automation Error Unspecified Error I click OK and it is immediately followed by another dialog box with the error: Property is write only. I really don't know where to start... I have attached the file I am having trouble with. I use the button on the second sheet to open the forms called "Treeview". Thanks in advance for your help. Craig 120514-JDE-ProcessMap-Documentat.xlsm 0 Question by:slobber72 Facebook Twitter LinkedIn Google LVL 39 Active today Best Solution byals315 I think you have problem with MS security update: http://support.microsoft.com/kb/2664258/en-us You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations: Go to Solution 7 Comments LVL 39 Overall: Level 39 MS Excel 14 MS Office 12 MS Applications 11 Message Active today Accepted Solution by:als3152012-08-21 I think you have problem with MS security update: http://support.microsoft.com/kb/2664258/en-us You can return back old version of mscomctl.ocx (unregister and register again) or try to follow this recommendations: http://dutchgemini.wordpress.com/2012/04/17/excel-vba-error-could-not-load-an-object-because-it-is-not-available-on-this-machine/ 0 LVL 44 Overall: Level 44 MS Excel 34 MS Office 13 MS Applications 11 Message Active today Expert Comment by:Martin Liss2012-08-21 It works normally for me. 0 LVL 39 Overall: Level 39 MS Excel 14 MS Office 12 MS Appli