excel 2003 automation error Charenton Louisiana

Networks, Consulting, Warranty, Repairs, Data Recovery, Network Cabling, Upgrades, On-site Repairs, In-shop Repairs.

As an Authorized Reseller and Service Center for Hewlett Packard and Xerox, we represent the best equipment in the market. From home computers to enterprise solutions, we provide the local touch, backed by world-class companies. We make a conscious effort to select the best possible hardware and software for use at our client sites. Cost-effective installation services are available for your entire office environment, including client PCs, workstations, mobile devices, routers, and other peripherals. We are authorized to service what we sell. There is no "finger pointing" between sales organization and manufacturer.

Address 1162 Barrow St, Houma, LA 70360
Phone (985) 879-3219
Website Link http://www.cssla.com
Hours

excel 2003 automation error Charenton, Louisiana

Automation errors may occur due to a variety of objects not being fully explicitly qualified (possibly all the way to Application level^), for example, workbook/worksheet/sheet/range/cells. Generated Thu, 13 Oct 2016 20:20:29 GMT by s_ac4 (squid/3.5.20) | Search MSDN Search all blogs Search this blog Sign in The Microsoft Excel Support Team Blog The Microsoft Excel Support It works fine for between 74 and 86 loops and then suddently the CreateObject("InternetExplorer.Application") fails. I decided to use another computer to do some additional work on this file - mainly new formulas and outline, but no code writing.

If this isn't the root of your problem, it may be hiding in the code you haven't provided ie "stopSpreadsheetEvents", "findLastPriceIndexRow"*, "CopyDataFromRaw", "FillFormulasDown", "addLookUpValues", "importParameters", "CurrencyFormatString", & "PriceIndexWithStatus". * I have How to make files protected? Copy any ThisWorkbook / sheet module code from old to new Suggest don't attach the custom toolbar if that's what you had before, create / delete each time on load / Saturday, May 31, 2014 12:45 PM Reply | Quote 0 Sign in to vote Hi, thanks for the reply.

Copying the code out, deleting it, and copying back in forces Excel to regenerate the p-code. When unprotecting the sheet and running a small job on that particular sheet it was again impossible to perform a double click due to a protection status I could not remove. The Locals window has one of the modules includes by itself. If on a 64-bit machine, type the following: regsvr32.exe /u C:\Windows\SysWOW64\MSCOMCTL.OCX Hit ENTER then type regsvr32.exe C:\Windows\SysWOW64\MSCOMCTL.OCX If on a 32-bit machine, type the following: regsvr32.exe /u C:\Windows\System32\MSCOMCTL.OCX hit ENTER then

From your description, I don't think we need to see any dummy data in the file*, but can you please upload a file that contains all the code? *hmmm, on second It just recently started. When I double-clicked that module (and the rest of them) I saw that the code is there and didn't bother with it, but if I would have gone down I would I like the machines to be compliant from a security point of view.

Reply Morphius says: August 16, 2012 at 8:27 am For 32bit machines that should probably read If on a 32-bit machine, type the following: regsvr32.exe /u C:Windowssystem32MSCOMCTL.OCX hit ENTER then type I have no integers, only longs. 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 Back then deleting the .exd files did the trick, but the current updates (including Service Pack 3) seem to be different.

eg. That said I can't think of any reason for a custom toolbar to cause the problems you described. Is that too crazy of an idea? And what about "double-click"?

If you continue to experience this pop-up, try going to your %APPDATA%MicrosoftForms folder and delete all of the .exd files. So for some reasons, when excel was auto-calculating it crashed (on opening) on some computers but not all. However, when removing the forms (and associated code) everything is fine. 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.

Rob, It turns out your suggested fix did the trick: the problem went away by simply adding: Please Login or Register to view this content. One thing I read around is about sharing and references. I've also included error handling: On Error Resume Next which doesn't prevent it. Attached Files out.txt‎ (13.2 KB, 68 views) Download Last edited by davidwe; 03-11-2010 at 04:43 AM.

Isn't that more expensive than an elevated system? "Rollbacked" or "rolled back" the edit? This line of code invariably will have some variable(s) that are not what they should be. try to delete a line and return it back. Also if I follow the exact same file opens fine in some 2003 systems but not in others.

myPriceArray.Sort. I have never opened a file through VBA but will try. Got me thinking though - I have loaded some custom toolbars on my excel that I am not sure all people within my company have. System.Collections.ArrayListeven works in Windows 8.1 Regular 64-bit with Excel 2010 32-bit, but whenI try to use it with Windows 8.1 Pro 64-bit, it bombs.

thanks! Thanks Friday, August 20, 2010 3:11 PM Reply | Quote 0 Sign in to vote If it weren't for one thing you mentioned I'd suspect the problem was most likely corruption I have worked on this file for long time and just recently did some cosmetic work on Excel 2007 on another computer. So I have auto-calc set to manual, and the following code in the worksheet: Private Sub Worksheet_Activate() A_Dates.Calculate End Sub This has worked fine for the last 3 months, day-in and

Added to the issues the previous 'fix' caused it all seems very badly managed. Does that generate an error? –mwolfe02 Sep 4 '12 at 21:17 Yes, it does generate the same error. Excel aborted and recovered after this. Hot Network Questions Near Earth vs Newtonian gravitational potential Truth in numbers Create a new command that supports superscript (^) and subscript(_) syntax Does the recent news of "ten times more

Andy Wednesday, June 04, 2014 12:45 AM Reply | Quote 2 Sign in to vote Hi Jim, Thanks for the suggestion - Success! And I'll also be revisiting clearing all the way to that last row, what with the better ways to find the last row (and the better use of clear rather than Always put your code between code tags. [CODE] your code here [/CODE] None of us is as good as all of us - Ray Kroc Actually, I *am* a rocket scientist. Once you start Excel back up with a workbook, Excel will generate those files again, and they should be the correct version.

Bizarre! 2 weeks later I did the updates on 2007 and I got the same error myself. Yes, it does look likeSystem.Collections.ArrayList is in VB.NET and not an Excel VB. Regards, Peter Thornton Friday, August 20, 2010 9:08 AM Reply | Quote 0 Sign in to vote Glad I got your curiosity! :) The file I worked on from scratch over share|improve this answer answered Sep 4 '12 at 22:03 Dick Kusleika 22.1k22647 add a comment| up vote 2 down vote accepted I found the issue.

Then we register the same file (MSCOMCTL.OCX). So after some inspection, I noticed this trouble-free system had different version of MSCOMCTL.OCX in windows\sysWOW64 then others. Any advice is welcome. when I click the stop button I can see that the calculation continues and in the end when I go to the sheet using the custom function, all but one cell

Andy *************** Here's the Code That Stops the Macro Option Explicit Private Sub CommandButton1_Click() Dim myPriceArray As Object '****** '* Excel crashes on this next command here with a '* "Run-time