excel 2007 visual basic unspecified error Choccolocco Alabama

We offer many computer services of which many can be preformed onsite for your convenience or if you prefer you may bring computer to our location in DeArmanville.We have a collective knowledge of more than 35 years experience in working with computers. We offer support in many areas of computing while focusing on teaching and developing your skills.

Computer Cleaning Overall Computer Checkup Software Installation Hardware Upgrades Tutoring Network Setup Microsoft Home Server Setup Virus Removal Existing Computer Restoration Computer File Recovery Setup Computer Backup  

Address Anniston, AL 36207
Phone (866) 217-6911
Website Link http://www.dv-cs.net

excel 2007 visual basic unspecified error Choccolocco, Alabama

What if you >clear the reference to RefEdit on one of these machines? John C. Does that generate an error? –mwolfe02 Sep 4 '12 at 21:17 Yes, it does generate the same error. 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

Fortunately you were able to find the component and fix the problem. Glad you figured it out in time to answer a flurry of frantic phone calls from your users. 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 The app includes a form which has a number of combo boxes, list boxes and command buttons on it but nothing much else (no RefEdit controls).

Also, one of my clients has a large Excel add-in package which has experienced this error. But I am afraid not. I've reproduced the problem on another machine as well. That might be the place to look.

Munoz http://www.bzintelguru.com Jos says: Wednesday, December 2, 2009 at 10:43 am Detect & Repair worked, thanx. 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. My sheets will not run ref edit error on pre SP3. Exploded Suffixes Players stopping other player actions What is that the specific meaning of "Everyone, but everyone, will be there."?

Pardon my French, but WTF? Copying the code out, deleting it, and copying back in forces Excel to regenerate the p-code. In the Immediate pane, simple expressions such as ? 1 + 2 evaluate correctly, but anything that uses a function or object doesn't (e.g. ? I have them delete all temp files and all the EXD files.

No fussing about. Unspecified error Solution To correct the problem, follow these instructions: Open Excel Ignore the error message in the closing Click on "Tools" menu Add Uncheck "Tools for the euro" Close and All I did was comment out most of the lines on the code like 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 Thank you Mr.

John Nurick says: Tuesday, June 23, 2009 at 11:39 am Stupid of me. It sounds like a lot more work, but it isn't. Last edited by Prod1; Nov 11th, 2009 at 04:09 PM. Thanks.

I had to use a test system to simulate my end users' configuration and duplicate the error (which occurred each time the file was opened). I replaced these files with the backups of the 2007 files (which were installed by 2003). She needed to generate report from a macro workbook. But I am still sad because although one of the spreadsheets in question has a macro, the next one I looked at has nothing at all in the Open_Workbook event that

The time now is 03:32 AM. There are certainly macros on the files I am trying to open, so maybe that's the problem. I go through and wipe out the EXD files from time to time, just for target practice, but it seems to reduce funny business that occurs from time to time. But for the longest time this one eluded me.

This error has also been associated with ODBC, ADO, IMAP, ASP and IIS, and DLLs from Microsoft (INET and HTML controls) and third parties. Jon Peltier says: Thursday, March 18, 2010 at 4:19 pm BatGnat - Your solution works fine in a closed system. In between, IT department had forced installation of "security" hot-fixes. Guillaume BARRIO says: Thursday, January 12, 2012 at 8:58 am Okay, I am no VBA expert but had this "painful" error occurring on one computer belonging to an user working in

No: Help menu > Detect and Repair. Same thing if I try "Open and Repair" with the unlocked non-addin version. >Do you have access to an earlier version of Excel (e.g., 2000)? Flanagan for documenting the fix and sharing it with everyone. John Nurick says: Tuesday, July 7, 2009 at 6:55 am Our Citrix expert came back to me just as I was packing up for a few days' holiday.

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 Yesterday, it stopped working. On a computer that experiences the problem, the RefEdit library (refedit.dll) is not available in the references under the VB Editor's Tools menu,and sometimes it turns up as a MISSING reference I would assume the latter file is an English-only version, and may not exist in others' systems.

There is not a problem with the add-ins. Reason: spelling Reply With Quote Nov 11th, 2009,04:32 PM #2 emartinho View Profile View Forum Posts Addicted Member Join Date Apr 2009 Location Toronto, Ontario Posts 242 Re: Run-time error -2147467259 What happens if you perform a Detect and Repair? Generated Sat, 15 Oct 2016 08:54:40 GMT by s_ac15 (squid/3.5.20) TechCenter   Sign in United States (English) Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية

In the United States is racial, ethnic, or national preference an acceptable hiring practice for departments or companies in some situations? What if you do this on a machine on which the add-in is behaving? There are a lot of instances in which this error occurred in projects which dealt with retrieval of data from data controls or databases (Access, Oracle, SQL Server, and others). The compile step may not be necessary.

Is Microsoft has provided some fix for this issue if no then when it is expected since it is critical issue for our application as around 1200 users are going to One of my forms had a control on it that apparently stopped working, and this had a ripple effect. Could you please help me on this? I don't know how this will work on a Citrix thing.

All times are GMT -5. I suspect that this is a catch-all error message when there is an internal error in VB, when there is no specific information but the error is somehow associated with various The system returned: (22) Invalid argument The remote host or network may be down. Some software (such as Adobe PDF reader) do not remove DLLs on un-install, nor replace old with new.

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. Register Help Remember Me? The unchecking and compile did not work. It might be a particular combination of controls, which might somehow be at odds with updated libraries for these controls.

Even if I check the box to not show that prompt in future, it always does.