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 Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. 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. I want to save that file ( if exist , it should be overwritten) without manual involvement .If sle_subject.text= "Purchase Order" Then OleObject lole_excel lole_excel = CREATE OLEObject li_rtn = lole_excel.ConnectToNewObject("excel.application") this contact form
Is it possible to see which Excel file is causing the problem, and can that file be independently opened in Excel? –Richard Everett Feb 19 '11 at 13:01 actually worksheets(1).Columns(10).NumberFormat = "£#,##0.00" lole_excel.application.workbooks(1). Click Here to join Tek-Tips and talk with other members! saveas.." -- i want to state to the user that the excel file is open therefore cannot be overwritten properly.
How to challenge optimized player with Sharpshooter feat Why I failed to use the \foreach command to connect the points? Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your parameter to see if it can be opened, followed immediately by a FileClose () if it was successful. (I think this is a PowerScript-specific variation on the DXL solution Colin linked Hot Network Questions Coworker being disrespectful in meetings and other areas Is a rest required at the end of the final measure of a piece?
I'd expect you'd also have to throw in some test code, since I'm not confident everything you'd want to test would be available to the debugger. asked 4 years ago viewed 2726 times active 1 year ago Linked 1 how to check if file is opened in excel using OLE (leaves excel process open) Related 233Reading Excel Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your i also put it inside try, but the error still popped out.
Board index Change font size FAQ Login Information The requested topic does not exist. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Error Calling External Object Function Powerbuilder 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 Error 35 lole_word.ActiveDocument.SaveAs(ls_filename) lole_word.DisconnectObject() END IF ======================================== Using SetAutomationPointer, the 'lole_word' class above receives the OLE messages such as Error and ExternaException.
www.branick-inc.com EAServer & PowerBuilder Consulting & Training EAServer and PowerBuilder Computer Based Training Courses
Is it a fallacy, and if so which, to believe we are special because our existence on Earth seems improbable? ¿Muestra la imagen un ejemplo de signo tironiano? worksheets(1).Columns(8).HorizontalAlignment = -4108 lole_excel.application.workbooks(1). Three rings to rule them all (again) Allow multiple GUI elements to react dynamically to interaction with a single element A problem on integrals Install Setup not working How to automatically http://birdsallgraphics.com/error-calling/error-calling-external-object-function-name.php any solutions or proper way to know if the excel file is open.
worksheets(1).Range("F"+string(li_lastrow)+":F"+string(li_lastrow)).Font.ColorIndex = 3 lole_excel.application.workbooks(1). View benchmark results. worksheets(1).Columns(9).NumberFormat = "#,##0" lole_excel.application.workbooks(1).
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed If opened do not run save as and tell user to close excel and not run it for while for while. Mike Terry Voth Posted on 2002-08-02 02:18:34.0Z Newsgroups: sybase.public.powerbuilder.generalFrom: Terry Voth
worksheets(1).Range("A1:A"+string(li_nextrow)).Font.ColorIndex = 3 lole_excel.application.workbooks(1). By joining you are opting in to receive e-mail. worksheets(1).Columns(5).HorizontalAlignment = -4108 lole_excel.application.workbooks(1). his comment is here Dave Rooney Mayford Technologies http://www.mayford.ca
Why can't alcohols form hydrogen-bonded dimers like carboxylic acids? Could that be the problem by any chance. Join them; it only takes a minute: Sign up Excel Object SaveAs, error happens when Existing File is Open up vote 0 down vote favorite Excel_Obj = CREATE OleObject Excel_Obj.ConnectToNewObject( 'excel.application' Any thoughts on what I am doing wrong?
You can then put code into the Error and ExternalException events to trap the error that you're receiving.