Ole Error 800ac472 Delphi
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
Excel Output Failed Ole Error 800a03ec
site About Us Learn more about Stack Overflow the company Business Learn more microsoft office excel error '800a03ec' about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
800a03ec Vbscript Error
Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Ole 800A03EC error when using TExcelWorkBook 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,06122758 asked Mar 1 '10 at 13:15 Tofig Hasanov 71362359 add a comment| 4 Answers 4 active oldest votes up vote 9 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 ckN
this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register 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 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 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 http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 that updates every 100ms an excel doc., it works fine, but if the user clicks on the document he 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 http://www.dbforums.com/showthread.php?1080032-OLE-error-800AC472-while-updating 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 General New Members & Introductions Applications & Tools Database Concepts & Design Chit Chat Marketplace Job Opportunities Suggestions & Feedback Links to other iNet owned sites web development forum Web Hosting Talk « Previous Thread | Next Thread » Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off [VIDEO] code is Off HTML code is Off Forum Rules Login Log in with your username and password Remember Me? Forgot your password? Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers heal
ellátogattál hozzánk, de sajnos úgy http://prog.hu/tudastar/30427/excel-szerkesztese-kozben-ole-error-800ac472-uzenet tűnik, hogy az általad jelenleg használt böngésző vagy annak beállításai nem teszik lehetővé számodra oldalunk használatát. A következő problémá(ka)t észleltük:Le van tiltva a JavaScript. Kérlek, ole error engedélyezd a JavaScript futását a böngésződben! Le van tiltva a sütik használata. Kérlek, engedélyezd a sütik használatát a böngésződben!Miután orvosoltad a fenti problémá(ka)t, kérlek, hogy ole error 800ac472 kattints az alábbi gombra a folytatáshoz:» Rendben. Javítottam a problémákat « Ha úgy gondolod, hogy tévedésből kaptad ezt az üzenetet, a következőket próbálhatod meg a probléma orvoslása végett:törlöd a böngésződ gyorsítótáráttörlöd a böngésződből a sütiketha van, letiltod a reklámblokkolód vagy más szűrőprogramodatmajd újból megpróbálod betölteni az oldalt.abcdMenüHírekVideókTársalgóTudástárCikkekWikiAndroidC#C++CSSDelphiFlashHTMLiOSJavaJavaScriptMySQLNoSQLOraclePascalPerlPHPPythonSQLVisual BasicVisual C++Windows Phone…cikkekbenhírekbentársalgótémákbantudástártémákbantársalgóbantudástárbanvideók közöttfókuszcikkekbenBelépésRegisztráció Hírek és videókFórumokFacebookTwitterGoogle+Napi hírlevélHasználati feltételekAdatvédelemImpresszumMédiaajánlatRegisztrációElfelejtett jelszóHírlevélMint minden weboldal, a Prog.Hu is sütiket használ a jobb és biztonságosabb működés érdekében. További információk Rendben