SudhakarVE
New Contributor
Joined 10 years ago
User Profile
User Widgets
Contributions
Add New Worksheet at the End
Hi, I'm trying to add a new worksheet at the end of the workbook. The following add method adds the worksheet at the first sheet. VBA After:= with count is not working in test complete. sWritePath="Z:\Expected Data Report Files\ComSnapShot\Sample.xlsx" Set oXL = CreateObject("Excel.Application") Set oVPRWB = oXL.Workbooks.Open(sMainpath) Set oPCSExpWB= oXL.Workbooks.Open(sWritePath) oPCSExpWB.Worksheets.Add Appreciate any idea to add the new sheet at the end. Regards, SudhakarSolved2KViews0likes4Commentsget all the opened excel workbook names
Hi, I'm trying to get all the opened excel workbooks names and save it in different location by save as. The below VBA code does that but couldn't use it in test complete. The VBA code Dim wb as workbook For each wb in Workbooks wb.name wb.saveAs Next Appreciate any suggestion/idea to retrieve those excel work book names in test complete. Thanks in Advance. Sudhakar756Views0likes1CommentExcel Form Windows List object is not recognised
Hi: I'm trying to recognize the Web List control in Excel form through Test complete. It's being recognised as Aliases.EXCEL.wndThunderDFrame.F3Server5e880000.F3Server5e8800002 and to click a checkbox within it returns the x,y co-ordinates to click it as mentioned below Call F3Server5e8800002.Click(189, 313) Call F3Server5e8800002.Click(190, 32) Basically, it's list of check boxes basd on the text displayed next to it needs to be selected. Appreciate any suggestion to make/recognize it as windows list object to identify the particular check boxes. Thanks, Sudhakar1.5KViews0likes2Comments