Ole Error 800a03ec Excel Delphi
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings ole error 800a03ec excel 2013 and policies of this site About Us Learn more about Stack Overflow
Excel Output Failed Ole Error 800a03ec
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation
Microsoft Office Excel Error '800a03ec'
Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it
Ole Error 800ac472
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 800a03ec vbscript error 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
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help 800a03ec excel saveas Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > OLE Error 800A03EC Want to Advertise Here? Solved OLE Error 800A03EC Posted on 2012-11-22 MS Excel Delphi 1 Verified Solution 17 Comments 10,536 Views Last Modified: 2012-11-26 I am experiencing an OLE-Error 800A03EC which happens on a Windows XP 32-bit Service Pack 2 PC running Excel 2003. This http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 happens when I try to open a new workbook from Delphi 7, using the following commands try ExcelApp := CreateOleObject('Excel.Application'); except ShowMessage('Cannot start Excel/Excel not installed?'); Exit; end; ExcelApp.Workbooks.Add(-4167); // Add a new Workbook ExcelApp.Workbooks.Open(XLSstring); // Open a Workbook The Delphi program works perfectly on several different PC's all running different https://www.experts-exchange.com/questions/27944523/OLE-Error-800A03EC.html operating systems and different versions of Excel. But I have two PC's that it fails on. The one described above, and a Windows 7 PC running Excel 2007. I'm starting to think it must be regional settings or some sort of admin rights / operating system policies... Anyone have experience or ideas which with this OLE error? Thanks very much for your support in advance. Jon 0 Question by:JonathanGSK Facebook Twitter LinkedIn Google LVL 19 Active 3 days ago Best Solution byThommy ...and what is this??? ExcelApp.Range['A1:OM1'].Font.Bold:=True; ExcelApp.Range['D1:ON1'].ColumnWidth := 10 'A1:OM1' and 'D1:ON1' are not valid ranges!!! Try that and I'm sure that it will work... Go to Solution 17 Comments LVL 25 Overall: Level 25 Delphi 25 MS Excel 1 Message Active today Expert Comment by:Sinisa Vuk2012-11-22 Try to add worksheet without -4167 number. Look at a great example on ms site!! :-) http://support.microsoft.com/kb/231614 0 LVL 19 Overall: Level 19 Delphi 16 MS Excel 2 Message Active 3 days ago Expert Comment by:Thommy2012-11-22 What do you want to do? Open an existing workbook or a new one? To open a new Workbook: ExcelApp.WorkBooks.Add; Just call it without any parameter like -4167... To open an existing Workbook: ExcelApp.WorkBooks.Open(
I know it is specific to Excel (the "A" means facility related error). However, where are these specific codes documented? Online search of MSDN turned up nothing for me. Jim Rofka Delphi Developer Thu, 28 Dec 2000 http://www.delphigroups.info/2/21/273293.html 03:00:00 GMT Re:OLE Error codes (800A03EC) Doug: You might want to check the OLECTL.PAS unit. Typically, any OLE errors returned with a 800A as their prefix usually indicate a standard OLE control error (or status code). You'll find the OLE control errors listed in OLECTL.PAS. Try OR-ing the CTL_E_