Ole Error 800a03ec Excel
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 ole error 800a03ec delphi Us Learn more about Stack Overflow the company Business Learn more about hiring
Ole Error 800a03ec Excel 2013
developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the excel output failed ole error 800a03ec 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
Ole Error 800a03ec Excel 2010
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 ole error 800ac472 excel 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 ckNewInstance so you'll always work in a separate Excel instance. share|im
360 games PC games
800a03ec Vbscript Error
Windows games Windows phone games Entertainment All Entertainment
Microsoft Office Excel Error '800a03ec'
Movies & TV Music Business & Education Business Students & educators ole error 800a03ec excel 2007 Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All https://support.microsoft.com/en-us/kb/3001579 Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
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 https://www.experts-exchange.com/questions/27944523/OLE-Error-800A03EC.html Job Ways to Get Help 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 https://www.fast-report.com/en/forum/index.php?showtopic=1964 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 ole error Windows XP 32-bit Service Pack 2 PC running Excel 2003. This 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); // ole error 800a03ec Open a Workbook The Delphi program works perfectly on several different PC's all running different 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
Fast Reports forum>Fast Reports Products>FastReport 3.0 2 Pages 12> error when export a excel files Options lancelotshui View Member Profile Mar 2 2005, 03:44 AM Post #1 Newbie Group: Members Posts: 4 Joined: 8-February 04 Member No.: 391 when I export the report as a excel file.it always 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 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 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 ftorres View Member Profile Apr 27 2005, 08:08 AM Post #9 Newbie Group: Members Posts: 4 Joined: 3-March 05 Member No.: 1771 this worked for me: frxPrint1.PrepareReport;frxPrint1.Export(frxTXTExport);that will bring up the export dialog (according to your setting) and do the job.though an excel export is really slow for me.I rather use a TXT export and then use a step import procedure in Excel. Much faster. JiguJigu View Member Profile Jun 1