if you user run excel and your program still running active workbook and worksheet application will be switch to excel that opened by user ( imagine it wrong written data). Browse other questions tagged excel ms-office ole powerbuilder or ask your own question. 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. Why don't you connect unused hot and neutral wires to "complete the circuit"? this contact form
worksheets(1).Columns(10).NumberFormat = "£#,##0.00" lole_excel.application.workbooks(1). Lesa Lesa Posted on 2001-09-06 15:30:52.0Z Newsgroups: sybase.public.powerbuilder.ole-ocx-activexFrom: LesaDate: Thu, 6 Sep 2001 11:30:52 -0400Subject: Re: Error calling external object function (R0035)Lines: 3MIME-Version: 1.0Content-Type: text/plain; charset="us-ascii"Content-Transfer-Encoding: 7bitMessage-ID: <[email protected]>References: <[email protected]>Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!newsXref: forums-1-dub Thanks much, Mike Some additional Information: The PBBugTrace is as follows for the error: End class function __GET_ATTRIBUTE for class OLEOBJECT, lib entry _TYPEDEF Executing instruction at line 126 Executing object 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! http://stackoverflow.com/questions/9579658/excel-object-saveas-error-happens-when-existing-file-is-open
For example, you've got several calls that maintain the state of Excel within the loop (e.g. Where are the oil platforms in Google Earth? Your cache administrator is webmaster. not before.
share|improve this answer answered Feb 22 '11 at 16:12 Hugh Brackett 2,485618 Thanks for the Replay let me try that..I rectified that issue, actually i still dont know what Close Box Join Tek-Tips Today! Why IsAssignableFrom return false when comparing a nullable against an interface? Happy coding From pb developer.
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 = Powerbuilder Application Execution Error (r0035) Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Last posting was on 2001-09-06 15:30:52.0Z Lesa Posted on 2001-09-05 19:39:47.0Z Newsgroups: sybase.public.powerbuilder.ole-ocx-activexFrom: LesaDate: Wed, 5 Sep 2001 15:39:47 -0400Subject: Error calling external object function (R0035)Lines: 53MIME-Version: 1.0Content-Type: text/plain; charset="us-ascii"Content-Transfer-Encoding: 7bitMessage-ID: http://answers.microsoft.com/en-us/windows/forum/windows_vista-performance/error-35-error-calling-external-object-function/14149fa5-e608-429e-aaf3-37d5938966af A power source that would last a REALLY long time How to challenge optimized player with Sharpshooter feat How do hackers find the IP address of devices?
The code is working in a loop and I am able open and import around 600 Excel files. Register now while it's still free! The need for the Gram–Schmidt process A problem on integrals Can anyone explain why my normals have a mind of their own Is it a fallacy, and if so which, to share|improve this answer answered Jun 10 '15 at 6:39 Masa sih 7110 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google
excel ms-office ole powerbuilder share|improve this question edited Apr 7 '14 at 19:09 Kara 3,14473147 asked Mar 6 '12 at 7:39 Sid 32711742 add a comment| 5 Answers 5 active oldest http://nntp-archive.sybase.com/nntp-archive/action/article/%[email protected]s%3E To create it: 1) Go to 'File/New...', and then the 'PB Object' tab. 2) Select the 'Standard Class' icon and click OK. 3) When the 'Select Standard Class Type' dialog appears, Error Calling External Object Function Powerbuilder The code clip you've posted will never enter the block where the GarbageCollect() is called (ll_Excel_Cnt is never initialized), so you might want to make sure that part is working. Version 2.1.01 now available at the Sandbox ^ ^ o o =*= © Copyright Mon Oct 10 14:56:28 UTC 2016, SAP Inc. - Forums Archive v 2.2 × Sybase NNTP
Good luck, Terry share|improve this answer edited Feb 21 '11 at 17:39 answered Feb 20 '11 at 21:02 Terry 5,577916 Hai, Thanks for the replay –Jaibin Paul Feb 21 weblink Each "dot" in an OLE reference (attribute access, method call) creates an object in memory that isn't destroyed until the garbage collect. i also put it inside try, but the error still popped out. In 5.0.3 it worked fine with Word 97, but I recently > migrated the application to PB 8.0.1 Build 9056.
worksheets(1).Columns(9).NumberFormat = "#,##0" lole_excel.application.workbooks(1). Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Mitt kontoSökMapsYouTubePlayNyheterGmailDriveKalenderGoogle+ÖversättFotonMerDokumentBloggerKontakterHangoutsÄnnu mer från GoogleLogga inDolda fältSök efter grupper eller meddelanden Find product ...*Security ActiveXwodCryptwodSSHwodSFTPwodSSHServerwodSSHTunnelwodSSHpackagewodSFTPdll*Security .NETwodSSH.NETwodSFTP.NETwodFtpDLX.NETwodWebServer.NET*General ProtocolswodAppUpdatewodHttpDLXwodFtpDLXwodTelnetDLXwodFTPServerwodWebServerwodVPNwodXMPP*MailwodMailServerwodMailboxwodImapServerwodSmtpServerwodPop3ServerwodSmtpwodPop3*FreewodBeepwodDHCPServerwodShellMenu WeOnlyDo Discussion board Log inRegister Search: New topic RefreshOrderFold threadsTable view All http://birdsallgraphics.com/error-calling/error-calling-external-object-function-powerbuilder-ole.php All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission.
Mike Mike Posted on 2002-08-01 16:22:00.0Z Newsgroups: sybase.public.powerbuilder.generalFrom: MikeDate: Thu, 1 Aug 2002 12:22:00 -0400Subject: Re: OLE error 35 (repost)Lines: 8MIME-Version: 1.0Content-Type: text/plain; charset="us-ascii"Content-Transfer-Encoding: 7bitMessage-ID: <[email protected]>References: <[email protected]> <[email protected]> <[email protected]>Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!newsXref: forums-1-dub worksheets(1).Columns(7).HorizontalAlignment = -4108 lole_excel.application.workbooks(1). From the information you've supplied, it's impossible to tell if the OLE host has crashed and isn't responding anymore, or if you've got the OLE host into a state where these
Coworker being disrespectful in meetings and other areas A power source that would last a REALLY long time more hot questions question feed about us tour help blog chat data legal Dave Rooney Mayford Technologies http://www.mayford.ca
Wobj.ActiveDocument.SaveAs FileName:=FilePath & sFileName, FileFormat:= _ wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _ True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _ False, SaveNativePictureFormat:=False, SaveFormsData:=False, _ SaveAsAOCELetter:=False PB code... Excel.Application.Visible), when they only need to be called once. ls_str = gnv_app.of_getframe().is_app_path // Connect to Word 8 (starts Word 8) , if successful Opens employee.doc , // if unsuccessful , display msg box for "ole error". his comment is here Stopping time, by speeding it up inside a bubble Why is there a white line in Russian fighter jets canopy?
I really stuck with this issue, if anyone can help that will be grateful. Not the answer you're looking for?