excel 2010 vba automation error unspecified error Clifton Hill Missouri

Small home-based business.  Locally owned and operated by Columbia Native.  Over 25 years experience.

Address Columbia, MO 65201
Phone (573) 239-1737
Website Link

excel 2010 vba automation error unspecified error Clifton Hill, Missouri

New tech, old clothes need book id, written before 1996, it's about a teleport company that sends students learning to become colonists to another world Does the recent news of "ten Reply CMC says: September 26, 2012 at 5:12 am Like Mike, I also had to delete the exd files before the problem went away. Microsoft doesn't know about any side effects to deleting this registry key. This has solved my problem.

It usually reaches over 100 cases before it dies (randomly as I said earlier). How would they learn astronomy, those who don't see the stars? PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Misc > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick Covered by US Patent.

Hope this helps. -EM --- REMEMBER: If your issue is resolved, use the Thread Tools menu to set it as such, and be sure to rate the posts that help you Good Term For "Mild" Error (Software) What is a type system? You may have to register before you can post: click the register link above to proceed. No, create an account now.

What is that the specific meaning of "Everyone, but everyone, will be there."? Thanks. Apparently my browser was crashing and it wouldn't restart because of it (hence the restarts refreshing it)! –user3814832 Jul 11 '14 at 14:54 I'll put this down as an I use the button on the second sheet to open the forms called "Treeview".

NOTE: The following step is done at your own risk. In my case unregistering and then registering the mscomctl.ocx helped, thanks Reply Amirtharaj says: September 24, 2012 at 8:12 am The solution was very useful and resolved my issue. Here is a sample script which should do the job: reg delete hkcr\typelib\{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}\2.0 /f if exist %systemroot%\SysWOW64\cscript.exe goto 64 %systemroot%\system32\regsvr32 /u mscomctl.ocx%systemroot%\system32\regsvr32 mscomctl.ocxexit :64 %systemroot%\sysWOW64\regsvr32 /u mscomctl.ocx%systemroot%\sysWOW64\regsvr32 mscomctl.ocxexit If you require regsvr32 should be started with admin rights if you have vista or windows 7.

Generated Thu, 13 Oct 2016 20:48:44 GMT by s_ac4 (squid/3.5.20) MenuExperts Exchange Browse BackBrowse Topics Open Questions Open Projects Solutions Members Articles Videos Courses Contribute Products BackProducts Gigs Live Careers Vendor All rights reserved. Please follow the instructions on our page on how to repair Office to solve. This problem is costing us new and existing customers- it is a major problem.

That might be the place to look. Reply Anonymous says: October 15, 2016 at 1:46 am Well, the fact that a fix actually exists saved me, given that legacy apps company wide just suddenly stopped working. Appease Your Google Overlords: Draw the "G" Logo What is the most expensive item I could buy with £50? One of my forms had a control on it that apparently stopped working, and this had a ripple effect.

I changed that and didn't get that prompt window anymore, but still got the Run-time error -2147467259 (80004005). and then it works fine now. The time now is 03:46 AM. 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

Register To Reply 08-29-2012,10:30 AM #2 Kyle123 View Profile View Forum Posts Visit Homepage Forum Guru Join Date 03-10-2010 Location Leeds MS-Off Ver 2013 Win7 Posts 5,869 Re: Automation Error; Unspecified Log in or Sign up PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Misc > "automation error" "unspecified error" Discussion in 'Microsoft Excel Misc' started by ML Purdy, Jul Is the code too complex and I need to reduce it? I thinkwe are on thr right track here - but I can't find where to download mscomctl.ocx version 6.01.9833.

Let's not forget that we cannot uninstall it either. The existing code on the button is this: Private Sub CommandButton65_Click() Dim Browser As Object Set Browser = CreateObject("InternetExplorer.Application") With Browser .Navigate ("\\eh-app-d14\SHAREDDATA\Service Desk\SHIFTS\2009\SDSK Shift Rota 2009.xls") .StatusBar = True .Toolbar Update - 9/26/2012. Thanks.

I do not know WHY it stopped working, but removing the form (and, of course, all references to it) resolved the issue. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed It works fine for between 74 and 86 loops and then suddently the CreateObject("InternetExplorer.Application") fails. Thank you so much! –user3814832 Jul 12 '14 at 18:53 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up

I tried your solution but it did not help. Everything seems to work fine, it is just annoying as heck. Thanks also for posting the mscomctl.ocx file. ML Purdy, Aug 1, 2008 #4 Giriraj Guest RE: THX: "automation error" "unspecified error" Thank you Dave/Jim and Purdy for sharing this in the forum.

This seems to have resolved the problem! Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. If I restart my computer it will let me try again (for whatever reason) but it still doesn't finish. When the Excel docs are opened on an Office 2003 machine they just open.

Is there a place in academia for someone who compulsively solves every problem on their own? 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 I'm struggling to find where I can see details of the Workbook_Open event (I did a quick check on the web but the first suggestion - 'right-click on the page(?) to Please fix your product- release an update ASAP!!!!!!!

Is there any code in the your Excel file in the Workbook_Open event for example? I think it will probably help to create a single instance of IE initially, and then use that same object inside the loop to navigate the desired URLs. 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. All of them are getting an error either when opening Excel or when working on VBA: Microsoft Visual Basic --------------------- Automation error Unspecified error One of my users cannot save files

If there is some code which would open the excel docs in Excel (as opposed to in an IE window) then I could try that (actually that might be better). Yes, my password is: Forgot your password? Thanks EM. Has anyone seen similar behavior and can point me in the right direction?

ML Purdy Guest When opening Excel, I get multiple instances of this error in a Microsoft Visual Basic error box. DécioC posted Oct 13, 2016 at 11:28 AM Ubiquiti vs Homeplugs? Read Complete Post and Comments Tags: Dynamics GP Meet the Author Somakarpagamoorthy Kanagasabapathy Works for Business Experts Gulf in UAE - Dubai @soma_moorthy LinkedIn Google+ YouTube Blog Website About Dynamics Thoughts