Ole 800a03ec Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and
Ole Error 800a03ec Delphi
policies of this site About Us Learn more about Stack Overflow the ole error 800a03ec excel 2013 company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags excel output failed ole error 800a03ec 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 only takes
Ole Error 800ac472 Excel
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
Microsoft Office Excel Error '800a03ec'
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
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 800a03ec vbscript error a Full Time Job Ways to Get Help Expand Search Submit Close Search
800a03ec Excel Saveas
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,531 Views Last Modified: 2012-11-26 I am experiencing an http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 OLE-Error 800A03EC which happens on a 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); // https://www.experts-exchange.com/questions/27944523/OLE-Error-800A03EC.html Add a new Workbook ExcelApp.Workbooks.Open(XLSstring); // 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:Thommy2
Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] Automation Excel : Error 800A03EC To get replies by our experts at nominal charges, follow this link to buy points http://www.excelforum.com/showthread.php?t=1091364 and post your thread in our Commercial Services forum! Here is the FAQ for this forum. + Reply to Thread Results 1 to 2 of 2 Automation Excel : Error 800A03EC Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-01-2015,10:09 AM ole error #1 Antoine35 View Profile View Forum Posts Registered User Join Date 07-01-2015 Location France MS-Off Ver 2007 Posts 2 Automation Excel : Error 800A03EC Hello, I want to move an application, that is using an object automation Excel, from a server 2003 (32 bits) to a server 2012 (34 bits). The application is working well on the server 2003 but on the server 2012, after calling the procedure below ole error 800a03ec : MyObject = allouer an object Automation "Excel.Application" MyObject >>Workbooks>>Open( MonFichierXLS ) I get an error message : 'Error 800A03EC : ....' Any help would be very nice ! Thanks Register To Reply 07-02-2015,03:58 AM #2 Antoine35 View Profile View Forum Posts Registered User Join Date 07-01-2015 Location France MS-Off Ver 2007 Posts 2 Re: Automation Excel : Error 800A03EC I found the solution : http://www.developpez.net/forums/d13...rvice-windows/ The folder below has to exist: C:\Windows\SysWOW64\config\systemprofile\Desktop or C:\Windows\System32\config\systemprofile\Desktop Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and 1 guests) Tags for this Thread excel automation ole View Tag Cloud Bookmarks Bookmarks Digg del.icio.us StumbleUpon Google 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 HTML code is Off Forum Rules -- vB4 Default Style -- Mobile Style Premium -- Lightweight Contact Us ExcelTip.com Archive Top All times are GMT -4. The time now is 06:54 AM. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. All rights reserved.