Delphi Excel Ole Error 800a03ec
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have ole error 800a03ec excel 2013 Meta Discuss the workings and policies of this site About Us Learn ole error 800a03ec excel 2010 more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Ole Error Code 800a03ec In Microsoft Excel
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like
800a03ec Excel
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); excel output failed ole error 800a03ec 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
Fast Reports forum>Fast Reports Products>FastReport 3.0 2 Pages 12> error when export a excel files Options lancelotshui View
Microsoft Office Excel Error '800a03ec'
Member Profile Mar 2 2005, 03:44 AM Post #1 Newbie Group: Members 800a03ec vbscript error Posts: 4 Joined: 8-February 04 Member No.: 391 when I export the report as a excel file.it always ole error 800ac472 encounter errorit said "project xxx raised exception EOleException with message 'OLE error 800A03EC'".what had happened jdorlon View Member Profile Mar 2 2005, 10:48 AM Post #2 Newbie Group: Members http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 Posts: 7 Joined: 2-March 05 Member No.: 1764 more info: I have seen this too with excel 2003, but not with prior versions. lancelotshui View Member Profile Mar 2 2005, 06:24 PM Post #3 Newbie Group: Members Posts: 4 Joined: 8-February 04 Member No.: 391 I'm using win2k advanced server + delphi 7 enterprise + offiice 2k/ AlexTZ https://www.fast-report.com/en/forum/index.php?showtopic=1964 View Member Profile Mar 4 2005, 02:12 PM Post #4 Advanced Member Group: FR Team Posts: 2982 Joined: 16-October 03 Member No.: 4 Does this error happen when you export any report or only some kind of report? lancelotshui View Member Profile Mar 4 2005, 07:08 PM Post #5 Newbie Group: Members Posts: 4 Joined: 8-February 04 Member No.: 391 pdf,rtf,jpg,bmp are all okerror only happen in excel expor, AlexTZ View Member Profile Mar 7 2005, 04:58 AM Post #6 Advanced Member Group: FR Team Posts: 2982 Joined: 16-October 03 Member No.: 4 Please send the .fr3 and .fp3 files (.fp3 - save from preview) to tz@fast-report.com adolfo View Member Profile Mar 7 2005, 04:14 PM Post #7 Newbie Group: Members Posts: 2 Joined: 1-November 04 Member No.: 1294 I just have the same problem.Hope can be solved soon.Adolfo ftorres View Member Profile Apr 26 2005, 01:14 PM Post #8 Newbie Group: Members Posts: 4 Joined: 3-March 05 Member No.: 1771 I have the same problem for FR3 + Delphi7 on WinXP Pro f
Error 800A03EC in Excel ... cause found, but ... ¿ how to solve ? Subject: Error 800A03EC in Excel ... cause http://borland.newsgroups.archived.at/public.delphi.oleautomation/200702/0702021870.html found, but ... ¿ how to solve ? Posted by: http://www.progtown.com/topic937059-error-ole-error-800a03ec-at-export-in-excel-2003.html Lluis Olle (llob.correobasura…@menta.net) Date: Fri, 2 Feb 2007 Hi all, I use XL Report to generate Excel Reports. This component uses OLE automation to get its work done. Randomly, some users complains about getting "OLE errror 800A03EC". The fact is that when this ole error error is triggered, the user has always some other Excel file(s) already opened. After searching Google, I've found one single reference that describes the problem ... and identifies the right cause ! So, the cause is that if you have another Excel file opened, and you have one cell in Edit mode ( so ole error 800a03ec the focus is in that cell, or in the edit text field of the formula toolbar ), then any OLE operation you try to do - for example, trying to generate an Excel Report with XL Report - will fail with OLE error 800A03EC. So ... anyone knows how to solve this "bad behaviour" of Excel ? For example, before generating the Excel Report, you could show a warning message to the user, saying something like "If you have some Excel file opened, please go to that file and hit ESC key to cancel any cell-edit operation ... or you will get an OLE 800A03EC error ..." ( which is - indeed - not a very good solution ! ). Any ideas ? ThanksReplies Re: Error 800A03EC in Excel ... cause found, but ... ¿ how to solve ? posted by Oliver Townshend on Sat, 3 Feb 2007 Newsgroups.Archived.At is © Copyright 2009-2016, A B Cryer, All Rights Reserved.
& Builder »Error "OLE error 800A03EC" at export in Excel 2003 Pages 1 You must login or register to post a reply Topic RSS feed Posts [ 6 ] 1 Topic by fenfz 2013-01-11 06:26:14 fenfz Member Offline Registered: 2012-04-22 Posts: 16 Topic: Error "OLE error 800A03EC" at export in Excel 2003 Greetings to all!There is an aaplet in which there is an outswapping in Excel not on cells, and the whole array:var I, J: Integer; ds: TADODataSet; //For Excel ExcelApp, Workbook, Sheet, Range: Variant; Massiv_Excel: Variant; //Coordinate with which the first table begins Begin_X, Begin_Y: Integer; ... //Creation of an array from Variant Massiv_Excel: = VarArrayCreate ([1, ds. RecordCount, 1, ds. Fields. Count + 1], varVariant); ds. First; //array Filling for I: = 1 to ds. RecordCount do begin Massiv_Excel [I, 1]: = I;//Number in sequence for J: = 1 to ds. Fields. Count do if ds. Fields. Fields [J - 1].FieldName = ' NAME_FIL ' then Massiv_Excel [I, J + 1]: = ds. Fields. Fields [J - 1].Value + ',' else Massiv_Excel [I, J + 1]: = ds. Fields. Fields [J - 1].Value; ds. Next; end; //Determination of area for record in Excel Range: = Sheet. Range [ToText (Begin_X + 2 {under title 2 of a line}, Begin_Y), ToText (Begin_X + ds. RecordCount + 1, Begin_Y + ds. Fields. Count)]; Range. Value: = Massiv_Excel;//Here there is an errorAnd the error arises, if in system is installed Excel 2003, and on versions 2007 and 2010 errors do not arise.Prompt, please, somebody faced such error? 2 Reply by Vladimir2009 2013-01-11 06:34:14 Vladimir2009 Member Offline Registered: 2009-03-04 Posts: 321 Re: Error "OLE error 800A03EC" at export in Excel 2003 fenfz;ds. RecordCount to that it is equal? 3 Reply by Leo Pevzner 2013-01-11 07:53:15 Leo Pevzner Member Offline Registered: 2012-05-03 Posts: 148 Re: Error "OLE error 800A03EC" at export in Excel 2003 Well about an amount of lines 65 to you already told, and there can be everything, everything further.To begin with to try to makeNumberFormat: = ''Further to search, on which data falls. For example, is there (2003/7/10 - any more did not check) such a bug that a