techgirlbb
Contributor
Joined 8 years ago
User Profile
User Widgets
Contributions
Re: How to save and close one excel file when multiple are open
Thank you for reply and suggestion.But the excel has test data which are using for DD Loop and updating the transaction ids to the same excel.so create work book is not an option. If the scripts gets error out at the middle, we are stoping the scripts. in that cases, the excel is alreay open and unable to open again. Madhu3.3KViews0likes4CommentsHow to save and close one excel file when multiple are open
Hi, Help Java script code on how to save and close one of the excel file when multiple are open. My current code is working fine if only one excel is open. function Excelclose() { let app = Sys.OleObject("Excel.Application"); if(app.Visible== true){ app.ActiveWorkbook.Save(); app.Quit() Log.Message("Excel closed successfully"); } else { Log.Message(" Excel is not running"); } } when myltiple excels files are open, due to App. quit, microsoft excel save popup is getting displayed ( refer the screen shot).I tried to giving detail of specific file name to save and close, some how not working. function Excelclose() { let app = Sys.OleObject("Excel.Application"); let filepath: C:\\users\\test.xlsx"; if(app.Visible== true) { app.ActiveWorkbook.Save(filepath); app.Quit() Log.Message("Excel closed successfully"); } can some one take a look at it and let me know where I am missing ? Thank youSolved3.6KViews0likes6CommentsRe: Documentation on salesforce lighting components
couple months back I did the POC the Lighting page using TC to my team.But I didnot have good experience with Test Complete in object identification. Took long time to identify the object. I need to change the path in the Name mapping for each and every object to make it work.Also has some issues to identify the objects too. Now I am at the point where I need to start script. Is there any documentation for setting or tips for such kind of applications? I am using TC12.60 Really appricate your help1.4KViews0likes1CommentRe: How can I click through the submenu items
Thank you robet. I captured the items from the parent and created array .It is working. But currently I have hardcoded the array values, I need to try using the way you had mentioned becuase I need to work with dynamic menu items for my other project.1.4KViews2likes0CommentsHow can I click through the submenu items
I have a panel("submenubar") listed with 10 services. when browse through the object , content text of Panel(Submenubar) listed all the services. How can I create function to click on each service by using the for loop. do i need to get the submenu names from conent tex EX: one of submenu pannel : Sys.Browser("iexplore").Page("https://gft.test.bremeronline.net/webapp/showpage.jsp").Frame("mainFrame").Panel("subMenuBar").Panel("DCMPOSTRPT")Solved1.7KViews0likes2Commentscould we hide/delete/mask some of results(steps) from Test results
I am creating regression test suite for applications daily sanity check at production Scenario:Suite contains 20 application, which needs same credentials.so I have created user form where the user entering the credentials once, storing them to a variables and passing them to each application. This minimizes the user keying in 20 times. Issue is: At the end of test run, I am seeing the input values user form (which is user if and password)- becuase of that we are unable to share the test resutls to team memebrs. Is there a way to mask those values in the resutls/or not capture the resulsts... or Always welcome other thoughts ond similar experienceSolved1.4KViews0likes2Commentsopening url in new browser window
Hi one of my team requirement is open an application in new browser window. if have the below Javascript code Browsers.Item(btChrome).Run("https://google.com"); which is replacing the existing active browser window url and lauching the application if any of browser currently open. Else lauching the application in new browser window. but the requirement is : Open an application in an new browser(Chrome) window even if the browser window opens. Do we have an y TC operation for it? I looked at the exisitng forum posts and tried didnot help. https://community.smartbear.com/t5/TestComplete-Functional-Web/Open-a-new-browser-window-function/m-p/86097?collapse_discussion=true&q=second%20browser%20window&search_type=thread https://community.smartbear.com/t5/TestComplete-Functional-Web/Opening-second-browser-window/m-p/122851?collapse_discussion=true&q=second%20browser%20window&search_type=threa1.9KViews0likes4CommentsRe: Chrome browser_ navigating to "chorme://apps" after launching application
Yes I agree, there is some thing going on in between. even I did check name mapping also.. nothing noticed with that url. Robert, Intially I had only navigate operation in my scripts, I noticed it is taking long time to load the application,so added run and navigate both. In that way it loads and naviagtes. This is salesforce application.. seeing all kind of issues like delay in object identification, not identifying objects when playing back.. I have modifed as you suggested, and executed it. Not going to Chrome://Apps page.But erroring out with objects doesnot exists during the play back.2.4KViews0likes1Comment