Compile Error Automation Error Excel
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 05 Oct 2016 16:27:23 GMT by s_hv972 (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 and policies of excel compile error object required this site About Us Learn more about Stack Overflow the company Business Learn
Excel Compile Error Object Library Invalid
more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question
Excel Compile Error Expected End Of Statement
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 takes a minute: Sign up http://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-msoffice_custom/excel-2007-compile-error-automation-error-on/c4e0edaf-9a51-4fd6-8aa1-2bce1dd2b1da 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 too many calculations in the for me to http://stackoverflow.com/questions/12270922/what-is-causing-automation-error-unspecified-error-on-worksheet-activate 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 2.8 Library Microsoft ActiveX Data Objects Recordset 2.8 Library vba error-handling excel-2007 share|improve this question edit
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 New Posts FAQ Calendar http://www.ozgrid.com/forum/showthread.php?t=179688 Forum Actions Mark Forums Read Quick Links Today's Posts What's New? Advanced 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 visit from the selection below. If you compile error 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 am stuck with an error where the macro work fines into excel compile error 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 the components that went missing or give me and idea where i should bang my head on.. Excel Video Tutorials / Excel Dashboar