excel automation error unspecified error College Corner Ohio

Address 818 Park Ave, Hamilton, OH 45013
Phone (513) 737-8500
Website Link http://comptroubcinci.com

excel automation error unspecified error College Corner, Ohio

Wednesday, September 03, 2014 7:34 AM Reply | Quote 0 Sign in to vote Hi mendonvikrant, Is there any more detail information? I tried your solution but it did not help. Does that generate an error? –mwolfe02 Sep 4 '12 at 21:17 Yes, it does generate the same error. This has solved my problem.

It's pointless, expensive, and possibly a source of error to be creating 100+ instances of IE. It is sometimes caused by getting Office pre-installed on the PC when you purchase the PC. I am totally at a loss. Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.

Your cache administrator is webmaster. Hot Network Questions What is the best way to upgrade gear in Diablo 3? Most likely there is a control on a form that requires a special DLL reference. 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

asked 4 years ago viewed 31842 times active 2 years ago Related 2Worksheet_Activate Code for New Sheets1VBA Select method errors0Calling VBA procedure - error missing =0VBA ADO connection to .xlsx file1VBA Mscomctl.zip 0 Message Author Closing Comment by:slobber722012-08-21 Thankyou very much for your prompt help. The solution is to un-install and then re-install the software that installed the DLL. Our add-ins do not use DLLs, so we avoid this issue.

How to solve the old 'gun on a spaceship' problem? 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. Difficult to pinpoint a problem if it's happening in various places. All rights reserved.

If this eliminates the error (after commenting out any code that may refer to the control you removed), then the problem is the DLL. The time now is 04:00 AM. Then - I view one of the forms I have built in. sigh I don't like where this is heading ... –Farfromunique Sep 4 '12 at 21:23 Next step is to make sure you are not missing any references.

When must I use #!/bin/bash and when #!/bin/sh? asked 2 years ago viewed 4112 times active 2 years ago Related 0Automation Error Catastrophic Failure with VBA in Excel1Excel VBA: Wait for JavaScript execution in Internet Explorer1Automating the modification of 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. As my code visits each page, I need to pull back information.

Remember Me? The problem is often caused by un-installing a trial version of Excel 2007, a missing service pack or an Office patch that was automatically run by Windows. more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation 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

The system returned: (22) Invalid argument The remote host or network may be down. Home * About * Contact * Feedback * Upgrades * Money Back Guarantee * FAQ's Download Information * Ordering Questions * Support Product List * New Products * Free Products * I have attached the file I am having trouble with. Connect with top rated Experts 11 Experts available now in Live!

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 What is a type system? Microsoft Customer Support Microsoft Community Forums OSIsoft Home PI Square Community Learning Live Library Welcome, Guest Sign In My SupportContact UsResourcesDownloadsProducts Due to scheduled maintenance, the My Cases portion of the When closing Excel with PI DataLink enabled, you may also see the error "Compile error in hidden module: modAddin." Solution Typically, these errors can be resolved by searching for and deleting

Thanks also for posting the mscomctl.ocx file. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. In VBA IDE, Tools --> References... –mwolfe02 Sep 4 '12 at 21:27 | show 1 more comment 3 Answers 3 active oldest votes up vote 7 down vote We ran into 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

To work around this problem, unprotect the worksheet to enable the macro to run. Join & Ask a Question Need Help in Real-Time? You may need to un-register the DLL and delete it and then do the re-install. How to convert a set of sequential integers into a set of unique random numbers?

It's a free add-in, but you can do it manually too. Cheers. –David Zemens Jul 11 '14 at 15:14 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted One thing I notice is that you're continually