Ole Error 800a03ec
Contents |
here for a quick overview of the site Help Center Detailed answers to any ole error 800a03ec delphi questions you might have Meta Discuss the workings and policies of ole error 800a03ec excel 2013 this site About Us Learn more about Stack Overflow the company Business Learn more about excel output failed ole error 800a03ec hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow
Ole Error 800a03ec Excel 2010
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 ole error 800ac472 excel 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 (
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 800a03ec vbscript error points and post your thread in our Commercial Services forum! Here is the
Microsoft Office Excel Error '800a03ec'
FAQ for this forum. + Reply to Thread Results 1 to 2 of 2 Automation Excel : Error 800A03EC Thread Tools
Ole Error 800a03ec Excel 2007
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 http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 07-01-2015,10:09 AM #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 http://www.excelforum.com/showthread.php?t=1091364 the procedure below : 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 07:06 AM. Powered by vBulletin® Version 4.1.8 Copyright ©
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 Expand Search https://www.experts-exchange.com/questions/27944523/OLE-Error-800A03EC.html 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 https://www.add-in-express.com/forum/read.php?TID=4734 MS Excel Delphi 1 Verified Solution 17 Comments 10,531 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 happens when I ole error 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 operating systems and different versions of ole error 800a03ec 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(
blogs Add-in Express forums > Add-in Express for Office and VCL forum Sometime i get "OLE error 800A03EC" when i call _VBProjects in delphi. tran van huy Posts: 17 Joined: 2009-02-02 :cry: Help me. I used codelines: ............ var vbPrjs:_VBProjects; .............. vbPrjs:=_addin.ExcelApp.VBE.VBProjects; //_addin:TAddinModule but it appear message in exception OLE error 800A03EC. I use office 2007, delphi 7, add-in-express 2008Ai bảo coder gàn dở, dòng code kia ai bảo chả có hồn!? Posted 02 Feb, 2009 23:22:29 Top Andrei Smolin Add-in Express team Posts: 12759 Joined: 2006-05-11 Hello Tran, Isn't it Excel? Isn't a cell edited when you get this? You can check this by setting ExcelApp.Interactive to false in a try/catch. If you catch an exception then sure, the user is editing a cell. Don't forget to restore the initial state of Interactive :) Regards from Belarus (GMT+2), Andrei Smolin Add-in Express Team Leader Posted 03 Feb, 2009 06:01:12 Top tran van huy Posts: 17 Joined: 2009-02-02 Thnks Andrei Smolin. When I set Macro setting "Enable all macro := true" it work fine! So I was set registry to check it!Ai bảo coder gàn dở, dòng code kia ai bảo chả có hồn!? Posted 03 Feb, 2009 22:54:20 Top Products & technologies Office add-ins in .net Office addins in Delphi VDProj to WiX Converter Advanced Outlook Regions for VSTO Outlook forms and views Website Links Add-in Express Blog Samples HowTo samples for developers Sample add-ins for Excel, Word, Outlook Developer Guides Add-in Express for Office and .net Add-in Express for Office and Delphi Add-in Express for Internet Explorer Designer for WiX Toolset Outlook Security Manager Sign In | Sitemap | Advanced search Company HomeLatest newsBlogsCustomers saySuccess storiesCustomers sayOur products in action Add-in Express reviewsAbout Add-in ExpressAbout usTeamContact us Products Produc