BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Automation error handling with Delphi 5 and Excel 97+          BorlandTalk.com Forum Index -> Delphi OLE Automation View previous topic :: View next topic   Author Message Guest Posted: Wed May 16, 2007 12:54 am    Post subject: Automation error handling with Delphi 5 and Excel 97+ Hello, I created a Delphi 5 application that sends data to an Excel 97 or later worksheet. I used the nice tips on this site: http://www.djpate.freeserve.co.uk/Automation.htm Everything works as expected. If data is being written to the worksheet and a unrelated cell is accessed manually in the same worksheet Excel gives a "call rejected by callee" error. I would expect for this to happen since that would require for Excel to process two commands at the same time. What I would like to know is if there is a way to prevent the worksheet to be edited manually while data is being sent to it. Or is there another way of avoiding this error more elegantly than just telling the user to not touch the worksheet while it is being filled. thanks for your attention, FlyerX Back to top Oliver Townshend Guest Posted: Wed May 16, 2007 3:08 am    Post subject: Re: Automation error handling with Delphi 5 and Excel 97+ Quote: What I would like to know is if there is a way to prevent the worksheet to be edited manually while data is being sent to it. Or is there another way of avoiding this error more elegantly than just telling the user to not touch the worksheet while it is being filled. Make it non-visible? Oliver Townshend Back to top Guest Posted: Wed May 16, 2007 11:38 pm    Post subject: Re: Automation error handling with Delphi 5 and Excel 97+ On May 15, 5:08 pm, "Oliver Townshend" <oliveratcodelegaldotcomdotau> wrote: Quote: What I would like to know is if there is a way to prevent the worksheet to be edited manually while data is being sent to it. Or is there another way of avoiding thiserrormore elegantly than just telling the user to not touch the worksheet while it is being filled. Make it non-visible? Oliver Townshend Thanks for the suggestion but Excel should be visible for the user to know that the worksheet is being filled. Besides the worksheet being access may be opened before my program runs. It would be rather shocking to a user to see his worksheet suddenly disappear from the desktop. FlyerX Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi OLE Automation All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.