Compile Error Automation Error Vba
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the compile error vba excel workings and policies of this site About Us Learn more about
Compile Error Vba Sub Or Function Not Defined
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Vba Compile Error Expected =
Jobs Documentation Tags 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.
Vba Compile Error Next Without For
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) that needs to be calculated when it is activated (It may be worth noting that this is in my Personal macro workbook). I regularly vba compile error can't find project or library 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 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 Ru
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 00:29:39 GMT by s_hv902 (squid/3.5.20)
VBA Code & Other Help Excel Help Compile Error: Automation Error 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 http://www.vbaexpress.com/forum/showthread.php?39821-Compile-Error-Automation-Error link above to proceed. To start viewing messages, select the forum that you want http://www.tek-tips.com/viewthread.cfm?qid=1681635 to visit from the selection below. Results 1 to 7 of 7 Thread: Compile Error: Automation Error Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-15-2011,06:32 AM #1 Hoopsah View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov 2007 Posts compile error 299 Location Compile Error: Automation Error Hi I recently got an upgraded computer from IT and now cannot get one of my old programs to work. When I open the Excel file everything works as it should, however, when I try to save I get a pop-up stating that Document could not be saved, I click ok, and then every cell I click on is greeted with a pop-up stating Automation vba compile error Error I have tried on someone elses PC and all was fine I assume I am missing a library or object but I have exhaused google to no avail Any help apprecieted Hoops I am playing all the right notes, but not necessarily in the right order. Eric Morecambe Reply With Quote 11-15-2011,06:46 AM #2 Paul_Hossler View Profile View Forum Posts View Blog Entries View Articles VBAX Guru Joined Apr 2007 Posts 4,126 Location In the VBIDE Tools, References, and see if any are #Missing Paul Reply With Quote 11-15-2011,07:12 AM #3 Hoopsah View Profile View Forum Posts View Blog Entries View Articles VBAX Tutor Joined Nov 2007 Posts 299 Location I did check the other user and all that had ticked were: Visual Basic for Applications Microsoft Excel 10.0 Object Library OLE Automation Microsoft Office 10.0 Object Library I have the same ticked within my VB I am playing all the right notes, but not necessarily in the right order. Eric Morecambe Reply With Quote 11-15-2011,05:08 PM #4 mdmackillop View Profile View Forum Posts View Blog Entries View Articles AdministratorVP-Knowledge Base VBAX Grand Master Joined May 2004 Location Scotland Posts 12,873 Location With Vista & Win7 you cannot save to the root folder (C Drive) using code. MVP (Excel 2008-2010) "
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. VBA Visual Basic for Applications (Microsoft) Forum at Tek-Tips HomeForumsProgrammersLanguagesVBA Visual Basic for Applications (Microsoft) Forum Excel VBA -- Compile Error: Automation Error thread707-1681635 Forum Search FAQs Links MVPs Excel VBA -- Compile Error: Automation Error Excel VBA -- Compile Error: Automation Error cebalaw (Programmer) (OP) 26 Apr 12 11:34 I wrote an Excel VBA program for my company that has been utilized for about a year with over 350 users, all running Windows XP and Office 2007. A handful of users who receive a new laptop (same as mine), have experienced a "Compile Error: Automation Error" when they attempt to run the program. There are no error codes, and the compile error points to a procedure declaration that compiles fine on other PCs: "Public Function KeyFound(strKey As String, SourceCollection As Collection) As Boolean". I have commented out the procedure only to get another compile error at a different procedure. I checked for missing references and found none; I have disabled any Add-Ins; I tried to delete all .EXD files; nothing works. One user reinstalled Office and got the program to run, another, needed to have IT rebuild his laptop and got it to work. I need to find the problem so I don't have to keep having users rebuild their laptops. Any help would be greatly appreciated. RE: Excel VBA -- Compile Error: Automation Error SkipVought (Programmer) 26 Apr 12 11:43 hi,It happens, from time to time, when I