excel visual basic automation error unspecified error Dolphin Virginia

Address 215 S Mecklenburg Ave, South Hill, VA 23970
Phone (434) 689-6300
Website Link http://bitbroadband.com
Hours

excel visual basic automation error unspecified error Dolphin, Virginia

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 Results 1 to 7 of 7 Thread: [RESOLVED] Run-time error ‘-2147467259 (80004005)’: Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to East Coast Time 7 days a week Home Products Complete add-in list New add-ins Free add-ins Trial versions Accounting add-ins Business and risk analysis add-ins Charting add-ins Data add-ins Downloadable macro There are certainly macros on the files I am trying to open, so maybe that's the problem.

Sometimes, particularly with heavy editing, the p-code gets corrupted. E-mail us or call us 302-584-1771, 8AM to 10PM U.S. Your work is done'. Reply karen says: December 18, 2012 at 12:32 am The manual correction worked beautifully!

Greatly appreciated !! At first I was afraid I'd be petrified Are there any rules or guidelines about designing a flag? and then it works fine now. share|improve this answer answered Aug 16 '12 at 0:06 Marc 1 add a comment| up vote 0 down vote Un- and registering the MSCOMCTL.ocx did the trick for me: Open an

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 Meaning of S. Reply Real Estate Flyer Builder says: December 1, 2012 at 12:41 am Please release an update to fix this problem. I regularly have workbooks open that have too many calculations in the for me to have auto-calculation on.

Open a command prompt window. Thanks also for posting the mscomctl.ocx file. A black command prompt opens. We finally narrowed it down to MS12-060 this morning just to discover this acticle after the fact.

Join the community of 500,000 technology professionals and ask your questions. All times are GMT -5. The solution works like a charm, but needed to restart Outlook after re-registering MSCOMCTL.OCX Reply Mauricio says: August 20, 2012 at 1:07 pm Does this problem affect also the old VB6 Running Windows 7 (same happening on Vista machine) and Office 2007.

Default Folders: XP: C:Documents and Settings%USERNAME%Application DataMicrosoftForms Vista/7: C:Users%USERNAME%AppDataRoamingMicrosoftForms Reply dude says: August 30, 2012 at 11:20 am Any chance of a revised version of this update? Check your References (In VBA IDE, click Tools and References) and to see where each DLL is pointing. Browse other questions tagged vba error-handling excel-2007 or ask your own question. With new (6.01.9834) I have same error.

share|improve this answer answered Sep 5 '12 at 4:59 Farfromunique 1311112 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign 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 New tech, old clothes This riddle could be extremely useful Near Earth vs Newtonian gravitational potential Solve and naming variables Which day of the week is today? Just copy your code out of the module and into a text file (or right click and Export).

Why is it a bad idea for management to have constant access to every employee's inbox Is it possible to have a planet unsuitable for agriculture? In cases where the re-registration doesn't work and you still get the error, you will need to open the registry editor (START > RUN > REGEDIT) and find andDELETE the following But obviously don't want to affect 100s of users by pushing out the existing update. Let us connect computers Resources Excel problems solved by our add-Ins Excel and PC tips Excel and Office newsletters Excel and Office user groups Excel and Office training Links to other

All the code is unchanged and has survived all previous windows/office updates. Thank you. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Maybe I need to check on an Office 2007 machine).

Reply Anonymous says: October 15, 2016 at 3:28 am Well, the fact that a fix actually exists saved me, given that legacy apps company wide just suddenly stopped working. Join our community for more solutions or to ask questions. Back then deleting the .exd files did the trick, but the current updates (including Service Pack 3) seem to be different. What's the most recent specific historical element that is common between Star Trek and the real world?

Strange that it's fine on Office 2003 PCs though. To do this, follow these steps: 1. Job done :-) Thanks to EM, and to anyone else who looked and was thinking about this. Thanks.

Join them; it only takes a minute: Sign up What is causing “Automation error Unspecified error” on Worksheet_Activate? It's the same with all buttons which launch an Office document. The time now is 05:28 AM. Oddly, one system had no issues despite the update - the newest system.

Any help appreciated. Never mind, I'm nothing if not tenacious and I think I've fixed it! 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