Ole Error Code 800a03ec
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 Us Learn more about Stack Overflow the company Business Learn more about 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 is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up open excel file on the above folder with watir/Ruby up vote 0 down vote favorite At moment I am open an Excel file like this excel = WIN32OLE::new("excel.Application") workbook = excel.Workbooks.Open('T:\\PointOfSale\\Projects\\Automated Testing\\MasterFile.xls') worksheet = workbook.WorkSheets(1) # Get first workbook site = worksheet.Range('A2').Value # Get the value at cell in worksheet. and its fine but when i move the scrip to a server i am getting an error message that the Path/file cannot be found. So i decide to user a generic way like when i open a text files excel = WIN32OLE::new("excel.Application") workbook = excel.Workbooks.Open('../../../../Automated Testing/MasterFile.xls') worksheet = workbook.WorkSheets(1) # Get first workbook site = worksheet.Range('A2').Value # Get the value at cell in worksheet. but i get an error message: T:/PointOfSale/Projects/Automated Testing/CSA/Branch_Test/Res Processing/CancelRes/Canc_BE.rb:23:in method_missing': (in OLE methodOpen': ) (WIN32OLERuntimeError) OLE error code:800A03EC in Microsoft Excel '../../../../Automated Testing/MasterFile.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files, make sure that the file has not been renamed, moved, or deleted. HRESULT error code:0x80020
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 Us Learn more about Stack Overflow the company Business Learn more about 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 is a community of 6.2 million programmers, just like you, helping each other. Join them; http://stackoverflow.com/questions/15546966/open-excel-file-on-the-above-folder-with-watir-ruby 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); 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" http://stackoverflow.com/questions/2355998/ole-800a03ec-error-when-using-texcelworkbook-saveas-method-in-delphi-7 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 (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
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Samples https://social.msdn.microsoft.com/Forums/en-US/dc426a10-f514-4daf-9ae0-828beb3533c9/ole-error-0x800a03ec-when-updating-excel-2003-worksheet?forum=visualfoxprogeneral Retired content We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: OLE error 0x800a03ec when updating Excel 2003 worksheet Visual FoxPro > Visual FoxPro General Question 0 Sign in to vote Hi All, I encountered an error ole error "OLE error code 0x800a03ec unknown COM status code" when I try to update the cells in an Excel 2003 preformatted worksheet with my VFP9 program. Basically just filling in values into the selected cells of the worksheet. The funny thing is that it works fine on some PCs and does not in a couple of similar PCs. All PCs are using Windows XP Professional. I ole error code searched and found only this from Microsoft, http://support.microsoft.com/kb/823988/en-us but no help. My VFP program just fill in data in the preformatted worksheet. Since it works fine in some, I don't think it's the VFP program. Any suggestion or idea is appreciated. Thanks in advance. Regards Daniel Thursday, July 24, 2008 3:12 AM Reply | Quote Answers 1 Sign in to vote reinstall excel on problematic pcs. Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Saturday, November 17, 2012 3:49 AM Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, November 26, 2012 6:54 AM Wednesday, November 14, 2012 2:57 PM Reply | Quote Answerer All replies 1 Sign in to vote you may check this link if it gives you any idea:http://www.foxite.com/archives/0000092649.htm Thursday, July 24, 2008 4:45 AM Reply | Quote 1 Sign in to vote No, doesn't help. It works on certain PCs so I don't think it is the program. I believe it is probably the MS Office 2003 edition or version that is probably causing this. I have yet to check if the versions were different in the PCs. What does "OLE error 0x800a03ec unknown COM status code" me