Error Calling External Object Function Saveas Powerbuilder
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 error calling external object function powerbuilder this site About Us Learn more about Stack Overflow the company Business powerbuilder application execution error (r0035) 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 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error on Excel importing up vote 1 down vote favorite I am trying to import around 1500 Excel files to my system. The code is working in a loop and I am able open and import around 600 Excel files. After that I am getting an error message like: Error calling external object function open at line 55..... I really stuck with this issue, if anyone can help that will be grateful. Code posted in reply comments: For ll_LoopCnt = 1 To Dw_1.rowcount( ) Ls_File_Name = Dw_1.getitemstring( ll_LoopCnt, "file_name") Ls_Path =Dw_1.getitemstring( ll_LoopCnt, "file_path") ll_Sr_No= Dw_1.getitemNumber( ll_LoopCnt, "sr_no") ldt_File_Date= Dw_1.getitemDateTime( ll_LoopCnt, "file_date") Excel.Application.DisplayAlerts = "False" Excel.WorkBooks.Open( Ls_Path ) Excel.Application.Visible = False Excel.windowstate = 2 // 1 : Normal, 2 : Minimize, 3 : Maximize Excel.Application.CutCopyMode = False Lb_sheet_rtn = excel.worksheets(7).Activate Ls_ClipBoard = clipboard() Excel.Application.ActiveWorkbook.Save() Excel.Worksheets(7).UsedRange.Copy ll_cnt = ds_1.importclipboard() IF ll_cnt <= 1 THEN Messagebox("Error", "Could not find.") Else Dw_1.Scrolltorow( ll_LoopCnt ) Dw_1.SetItem( ll_LoopCnt, "status", 'Success') For ll_Inner_LoopCnt = 1 To Ds_1.RowCount( ) Ds_1.Object.file_path[ll_Inner_LoopCnt] = Ls_Path Ds_1.Object.file_name[ll_Inner_LoopCnt] = Ls_File_Name Ds_1.Object.file_sr_no[ll_Inner_LoopCnt] = ll_Sr_No Ds_1.Object.file_date[ll_Inner_LoopCnt] = ldt_File_Date Next END IF Clipboard(ls_ClipBoard) Ds_1.Reset( ) //Reset the data store Excel.Application.ActiveWorkbook.Save() Excel.Application.ActiveWorkbook.Close(False); Excel.Application.Quit Excel.Application.CutCopyMode = False IF ll_LoopCnt = ll_Excel_Cnt Then //--->> After 100 files reset the memmory ll_Excel_Cnt = ll_LoopCnt + 100 Excel.DisConnectObject() DESTROY excel DESTROY TEst_Excel GarbageCollect ( ) Excel = Create OLEObject Test_Excel = Create OLEObject Li_rtn = excel.ConnectToNewObject("excel.application") IF li_rtn <> 0 THEN MessageBox('Excel error','can not run Excel Program') DESTROY Excel RETURN 0 END IF End IF Next Excel.displayalerts = False Excel.Application.Qu
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore http://stackoverflow.com/questions/5050888/error-on-excel-importing Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales https://scn.sap.com/thread/3395303 Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and Infrastructur
links to the respective forums on SCN, or you can go to SCN and http://nntp-archive.sybase.com/nntp-archive/action/article/%3C385_F0AB978564A8F6EA004D2E6285256C08.004D2E7585256C08@webforums%3E search for your product in the search box (upper right http://www.tek-tips.com/viewthread.cfm?qid=1036498 corner) to find your specific developer center. Forums Archive > PowerBuilder > General Discussion > "OLE error 35 (repost)" OLE error 35 (repost) 7 posts in General Discussion . Last posting was on 2002-08-02 16:47:44.0Z Mike Posted on 2002-08-01 14:03:01.0Z Newsgroups: sybase.public.powerbuilder.generalFrom: error calling MikeDate: Thu, 1 Aug 2002 10:03:01 -0400Subject: OLE error 35 (repost)Lines: 312MIME-Version: 1.0Content-Type: text/plain; charset="us-ascii"Content-Transfer-Encoding: 7bitMessage-ID: <385_F0AB978564A8F6EA004D2E6285256C08.004D2E7585256C08@webforums>Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!newsXref: forums-1-dub sybase.public.powerbuilder.general:20489 Article PK: 473278 List, This is a re-post with some additional information for a PBdebugtrace below this first note. Also below is the entire script for the event in question. Thanks, Mike error calling external I inherited an application written on PB 5.0.3 in which the below ole calls are made. In 5.0.3 it worked fine with Word 97, but I recently migrated the application to PB 8.0.1 Build 9056. In PB 8 with the same Word 97 I am getting Error number 35 errors. The below code is in the clicked event of a CB and the error "Error Number 35" "Error text=Error calling external object function saveas...." occurs during this event. As far as I can tell, the error is occuring whenever there is a "oleobject.ActiveDocument" in a line of code, for example, ole_object.ActiveDocument.SaveAs(ls_filename) //******* I have caught the return code from the connecting "ole_object.ConnectToNewObject("word.application.8") " and this is 0, indicating that the connection is working ok. I would appreciate any other leads anyone might have. Thanks much, Mike Some additional Information: The PBBugTrace is as follows for the error: End class function __GET_ATTRIBUTE for class OLEOBJECT, l
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Sybase: PowerBuilder Forum at Tek-Tips HomeForumsProgrammersDevelopment ToolsSybase: PowerBuilder Forum Error calling external object function saveas thread144-1036498 Forum Search FAQs Links MVPs Error calling external object function saveas Error calling external object function saveas joanneho (Programmer) (OP) 4 Apr 05 00:53 Hi everyone,Has any of you come across the error "Error calling external object function saveas at line xxx in clicked event of object xxx" ?I have using Powerbuilder6.5 and want to save a Word XP document on the XP server.Thanks.Joanne RE: Error calling external object function saveas mbalent (Programmer) 4 Apr 05 07:22 Check to make sure you have the proper permissions and that the drive/path are correct. "Nature forges everything on the anvil of time" RE: Error calling external object function saveas joanneho (Programmer) (OP) 5 Apr 05 21:50 Yes permission is fine because sometimes it works. We have recently upgraded to Windows XP and Office XP, do you think there is anything to do with this? Thanks. Red Flag This Post Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Cancel Red Flag SubmittedThank you for helping k