Error Calling External Object Function Name
Contents |
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing powerbuilder application execution error (r0035) and Revenue ManagementMaster Data Management for CommerceOmnichannel powerbuilder error 35 CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and error 35 error calling external object function AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive
Error Calling External Object Function Opendatasource
ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect powerbuilder application execution error r0002 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 InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterpri
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies powerbuilder application execution error r0039 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 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: https://scn.sap.com/thread/3431618 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 http://stackoverflow.com/questions/5050888/error-on-excel-importing 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 I
FAQ Login Information The error calling external requested topic does not exist. Board index The team • Delete all board cookies • All times are UTC - 4 hours Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
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 Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Error calling MSWord function from a Powerbuilder application Want to Advertise Here? Solved Error calling MSWord function from a Powerbuilder application Posted on 2003-12-03 Editors IDEs 1 Verified Solution 3 Comments 637 Views Last Modified: 2013-12-26 We are calling a function Opendatasource() which belongs to MSWord from a PB app, by initiating a OLE object of MSWord. It was working fine with Word97 and Word2000 ver. Now with Word2002, it is not working. I have tried many things suggested by Microsoft website,other PB developers, search results from Internet and Knet tech.experts,over a period of 2 weeks but of no use. If someone can help me resolve this, I greatly appreciate that. Since one requires more detail before attempting a solution, Thanks and regards 0 Question by:Meena_kumari Facebook Twitter LinkedIn Google LVL 2 Best Solution bymdhampton I noticed that the OpenDataSource documentation you show has 16 parameters, but your call has only 14. Are you missing SQLStatement1 and OpenExclusive? Have you tried working with the code in a VB Go to Solution 3 Comments LVL 33 Overall: Level 33 Editors IDEs 6 Message Expert Comment by:sajuks2003-12-03 can u post a part of ur code so that it could be more understandable ? 0 Message Author Comment by:Meena_kumari2003-12-03 Process flow : A Word document is stored in a Oracle database as blob. It is retrieved during run time into a Blob variable and then assigned to a OLE control (OLE_1.Objectdata = Blob variable). Then we declare a local variable of type "oleobject" and is initiated by OLE_1.object ( ole_object_variable = ole_1.object) Now onwards we use the local "oleobject" variable to execute MSword methods(functions) like ole_object_variable.mailmerge.opendatasource(...). MS Excel spread sheet is used as data source. We are NOT using "create" and "ConnectToObject" functions. This setup was working fine with older versions of MSWord & MS Excel. Opendatasource function description ... Ole_object.MailMerge.OpenDataSource(Name As String, [Format], [ConfirmConversions], [ReadOnly], [LinkToSource], [AddToRecentFiles], [PasswordDocument], [PasswordTemplate], [Revert], [WritePasswordDocument], [W