Excel Macro Compile Error Automation Error
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 site About Us Learn more about Stack Overflow the company Business Learn automation error vba more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags automation error excel Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, vba automation error unspecified error helping each other. Join them; it only 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)
Automation Error Vb6
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 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 vba automation error the object has disconnected from its client 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 21:43 asked Sep 4 '12 at 20:30 Farfromunique 1311112 If you comment that line out and manually force a Recalc (using [F9]) do you receive an error? –mwolfe02 Sep 4 '12 at 21:13 No, I do not. And, everything seems to calculate correctly. –Farfromunique Sep 4 '12 at 21:14 Maybe the error has to do with running any VBA, not necessarily the Calculate method. What if you try r
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 09:15:03 GMT by s_ac15 (squid/3.5.20)
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 http://www.ozgrid.com/forum/showthread.php?t=179688 Calendar 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 automation error 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 am stuck with an error where the macro work vba automation error 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,911 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..