Delphi Excel Ole Error 800ac472
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About excel output failed ole error 800a03ec Us Learn more about Stack Overflow the company Business Learn more about hiring 800a03ec vbscript error developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the microsoft office excel error '800a03ec' Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Ole 800A03EC error when using TExcelWorkBook
Ole Error Code 800a03ec In Microsoft Excel
SaveAs method in Delphi 7 up vote 4 down vote favorite 3 I am trying to open excel 2003 workbook and save it as something else, for example excel 95. I use the following code: XLSApp:=TExcelApplication.Create(Self); XLSApp.Workbooks.Open(SomeFileName,NULL,false,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,defaultlcid); XLSWB:=TExcelWorkbook.Create(XLSApp); XLSWB.ConnectTo(XLSApp.Workbooks.Item[1]); XLSWB.SaveCopyAs(ExtractFilePath(edTable.Text)+'temp.xls'); XLSWB.SaveAs(SomeOtherFileName,xlExcel7,EmptyParam,EmptyParam,False,False,xlNoChange,xlUserResolution,False,EmptyParam,EmptyParam,EmptyParam,DefaultLCID); Unfortunately this code gives "Ole 800A03EC" on clients computer, while it works on mine. Note that I have Office 2007 installed, and he has Office 2003 SP3. Any help would be very much appreciated. delphi excel automation ole share|improve this question edited Mar 2 '10 at 7:37 The_Fox 6,05122758 asked Mar 1 '10 at 13:15 Tofig Hasanov 69362358 add a comment| 4 Answers 4 active oldest votes up vote 8 down vote accepted I have seen this error once when automating Excel. It happened when the user had a cell in editmode and you tried to automate that instance. Excel doesn't like it when you are editing a cell and some program is fiddling around in the background. So this is what's happening at your client (I think): Your client has Excel open and is editing a cell (select a cell and press F2) Your code starts: You create a TExcelApplication and accesses the Workbooks property. Since your Excel application is not yet connected it calls TOleServer.Connect (look at the implementation of GetDefaultInterface) Since the default connectkind is ckRunningOrNew, TExcelApplication connects to the running instance. Because the client is editing a cell you get an error on the Open method. How you can prevent this: Set ConnectKind of your TExcelApplication to ckNewInstance so you'll always work in a separate Excel
OLE object and call Delphi function to update the data in spreadsheet. it works fine http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 under Excel 97/2000 for long time, but now under Excel 2002/2003, I got "OLE error 800AC472", it seems like the problem is that it take Delphi function too http://www.delphigroups.info/2/7/985626.html long to update the data in spreadsheet, after the script runs for about 2 minutes, that OLE error happens. (and if Delphi function only need 1 minute to update the spreadsheet, everything is fine). any hints? Regards, Simon 1. An idle rant2. Word Viewer-preview3. How about Blaise or Blaize4. Foxpro->Delphi5. Example of 4GL1. Support for what?2. ClientDataSet Master/Detail via MasterSource: Anyone actually using this?3. master detail (really apreciate help)4. +15. Re: how to add hyperlink in RitchEdit Control?
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register http://www.dbforums.com/showthread.php?1080032-OLE-error-800AC472-while-updating before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 http://www.solvusoft.com/en/errors/runtime-errors/microsoft-corporation/microsoft-excel/800ac472-excel-error-800ac472/ to 2 of 2 Thread: OLE error 800AC472 while updating Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch ole error to Hybrid Mode Switch to Threaded Mode 12-22-04,08:24 #1 diegolaz View Profile View Forum Posts Registered User Join Date Feb 2004 Location Argentina Posts 58 Unanswered: delphi app udating excel (OLE error 800AC472) Hi, I have delphi 7 app that updates every 100ms an excel doc., it works fine, but if the user clicks on the document he delphi excel ole is seeing I get an OLE error 800AC472 in the delphi app. If block the document, I can't update, and I can't unblock/block each time because since the update are each 100ms it's very easy for the user to click in the update.... any suggestions?? Thanks! diegolaz Last edited by diegolaz; 12-22-04 at 10:09. Reason: better title Reply With Quote 10-31-06,08:46 #2 Julot View Profile View Forum Posts Registered User Join Date Oct 2006 Posts 1 OLE error 800AC472 I have the same problem - did you get any answer ? Reply With Quote Quick Navigation Delphi, C etc Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scripts Visual Basic PC based Database Applications Brilliant Database Corel Paradox FileMaker Microsoft Access Microsoft Excel Other PC Databases Ge
DriverDoc WinSweeper SupersonicPC FileViewPro About Support Contact Errors Troubleshooting › Runtime Errors › Microsoft Corporation › Microsoft Excel › Error 800AC472 How To Fix Microsoft Excel Error 800AC472 Error Number: Error 800AC472 Error Name:Excel Error 800Ac472 Error Description: Error 800AC472: Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience. Developer:Microsoft Corporation Software:Microsoft Excel Applies to:Windows XP, Vista, 7, 8 Download NowWinThruster 2015 - Scan your PC for computer errors. Compatible with Windows 10, 8, 7, Vista, XP and 2000 Symptoms of Error 800AC472 "Error 800AC472" appears and crashes the active program window. Your PC frequently crashes with Error 800AC472 when running the same program. “Excel Error 800Ac472” is displayed. Windows runs sluggishly and responds slowly to mouse or keyboard input. Your computer periodically “freezes” for a few seconds at a time. These 800AC472 error messages can appear during program installation, while a Microsoft Corporation-related software program (eg. Microsoft Excel) is running, during Windows startup or shutdown, or even during the installation of the Windows operating system. Keeping track of when and where your 800AC472 error occurs is a critical piece of information in troubleshooting the problem. Causes of Error 800AC472 Corrupt download or incomplete installation of Microsoft Excel software. Corruption in Windows registry from a recent Microsoft Excel-related software change (install or uninstall). Virus or malware infection that has corrupted Windows system files or Microsoft Excel-related program files. Another program maliciously or mistakenly deleted Microsoft Excel-related files. Runtime Errors such as “Error 800AC472” can be caused by a variety of factors, so it is important that you troubleshoot each of the p