excel macro compile error automation error Cobbtown Georgia

Address 127 Jackson St, Vidalia, GA 30474
Phone (912) 537-1133
Website Link http://www.cybersouth.com
Hours

excel macro compile error automation error Cobbtown, Georgia

In Excel 2010 and 2013, via File, Options, Add-Ins. Skip,Just traded in my old subtlety...for a NUANCE! 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 Microsoft updated the MSCOMCTL.OCX to Version 2.2, if the Key {831FDD16-0C5C-11D2-A9FC-000F8754DA1} has an empty 2.1 or 2.0 Entry the Common Control will stop working.

If that doesn’t work, you can try repairing it. Cheers, Craig 22-08-2012-11-36-37-AM.jpg 0 LVL 39 Overall: Level 39 MS Excel 14 MS Office 12 MS Applications 11 Message Active today Expert Comment by:als3152012-08-21 Here is it (rename from txt What is that the specific meaning of "Everyone, but everyone, will be there."? Deutsche Bahn - Quer-durchs-Land-Ticket and ICE Near Earth vs Newtonian gravitational potential Can an ATCo refuse to give service to an aircraft based on moral grounds?

Daniel Alexander Karr & I can't be the 2 only one using TreeView Control 6.0 in our workbooks ??? –Thomas Basset Jan 19 at 9:50 add a comment| 3 Answers 3 EXD files are located in the following folder:In operating system XP or earlier: C: \ Documents and Settings \ USER \ Application Data \ Microsoft \ Forms \In operating system Vista Any other clues (fyi, I am accessing Google Patents with my code) –SJDS May 23 '14 at 9:30 add a comment| up vote 4 down vote Whenever I get strange errors 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".

Your answer helped me identify that the problem might be due to the "Microsoft ProgressBar Control". (Thank you very much) But instead of removing the form, I unregistered and registered the Hopefully it works for you too. THEREFORE, someting in the new environment is MISSING.I'd discuss this with your IT coordinator. To start viewing messages, select the forum that you want to visit from the selection below.

Any help appreciated. Join UsClose Loading Ozgrid Excel Help & Best Practices Forums

Register Help Remember Me? Your cache administrator is webmaster. share|improve this answer edited Jan 18 at 11:42 Andre 11.8k3935 answered Jan 15 at 12:45 Daniel Alexander Karr 1061214 Hi Daniel, this seemed promising, but unfortunately didn't seem to

The workbook doesn't work on that computer either. –Thomas Basset Jan 19 at 2:10 | show 4 more comments up vote 0 down vote Similiar problem here: Ancient Access 97 app Join them; it only takes a minute: Sign up Excel VBA “Automation Error” due to Jan 2016 Office Update, probably caused by MSCOMCTL.OCX (Microsoft Windows Common Controls 6.o (Service Pack 6)) I wish I knew what caused the registration of the control to go south - this is not the first time I've had to track down problems with this control. Then delete the code in the module, compile and save, and put the code back in.

Object Library not registered. If you don't like Google AdSense in the posts, register or log in above. 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 it's a modern post apocalyptic magical dystopia with Unicorns and Gryphons Using Java's Stream.reduce() to calculate sum of powers gives unexpected result This riddle could be extremely useful more hot questions

You may not have access to restricted resources of an antivirus system or prevent its proper installation.- Unable to run macro. You can determine if a plugin is disabled in Excel 2007 in Office Button, Excel Options, Add-Ins on the Disabled Application Add-ons section. Covered by US Patent. MSCOMCTL.OCX which lives in c:\Windows\SysWOW64\ KB2881029 (Security Update for Microsoft Office 2010 32-Bit Edition) (MS16-004), pushed out from Microsoft on the 15/01/2016 (or thereabout), installs a new MSCOMCTL.OCX (version 6.1.98.46 which

I have commented out the procude only to get another compile error at a different procedure. Update: Btw - I tried using an earlier version of MSCOMCTL.OCX and registered it using regsvr32 - now I get a BIG error: as per attached jpg. Close Box Join Tek-Tips Today! See more details at Microsost Support. 3.

Could you please explain further: -where the version (2.0,2.1,2.2) is referenced (right clicking on the file to get its property gives me 6.1.98.46). -what is the Key {831FDD16-0C5C-11D2-A9FC-000F8754DA1} ? This involves copious numbers of sheets, with many macros and a boatload of VBA behind the scenes. 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.. Not the answer you're looking for?

Solution: You should reinstall or repair the current installation of Excel, considering a full installation of all components and libraries. Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Click here to view the relaunched Ozgrid newsletter.

If there is a 2.0 (or 2.1 for that matter) SubKey with nothing in it, any object using that OCX should fail to create because it will use the 2.0 (resp One user reinstalled Office and got the program to run, another, needed to have IT rebuild his laptop and got it to work. Join Now For immediate help use Live now! Copying the code out, deleting it, and copying back in forces Excel to regenerate the p-code.

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 The failure is likely exiting the routine, meaning nothing else is running. 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, I tried your solution but it did not help.