Interested to Buy Any Domain ? << Click Here >> for more details...
i ve an excel in a QC folder. Thru my QTP script i want to
open that excel in runtime. I am running this script from
QC itself
- 4 Answers
- 16851 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / karishma
got to options and select folders tab and give path of the
folder where the excelsheet is present in QC
and then try out this:
x=PathFinder.Locate("Results.xls")
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
Set objWorkbook2 = objExcel.Workbooks.Open(x)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Can we record using all the modes in a single script? Explanation with example is appreciated
Describe how Smart Identification is used
How to get Traceability matrix from TD?
how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?
Can anyone pls tell me in realtime (descriptive programming) how will the properties of the object be given to the test team. R they given in an excel sheet and is the same sheet also given to the development team and by whom is this given? Thanks a lot.
What is checking bitmaps?
i have a doubt can anyone tell me where are scripts stored while using QTP.Tell me the exact procedure takes place in real time?like how we call scripts how to proceed after writing scripts?how scripts are executed etc?i heard some use Qc whether others dont use.so tell me whole procedure for both the things it will be a very big help.as i have interview i want to have whole idea on this.its very urgent.
What are the differences between quicktest professional and winrunner?
What is the difference between per-action and shared?
Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.
What is test object model in quicktest professional (qtp)?
What is the meaning Work bench?
if anyone has idea of the interview procedure in covansys, plz send me a mail?
i am looking job in perfomance testing using Loadrunner any one help me a project plz......?(Chandana) chs_29@rediffmail.com
How can we retrieve the Bug Ids which are open&Reopen in status through QTP scrit?Please find the script which i tried... Dim objBugFactory, objBug Dim BugId Set TDConnection = QCUtil.TDConnection Set objBug = TDConnection.BugFactory If QCUtil.IsConnected then Reporter.ReportEvent 0, "Connected", "Connected to server: " + QCUtil.TDConnection.ServerName + chr (13) +"Project: " + QCUtil.TDConnection.ProjectName + chr (13) + "Domain: " + QCUtil.TDConnection.DomainName Reporter.ReportEvent 0, "Current time on server is","==>" & TDConnection.ServerTime Else Reporter.ReportEvent 1, "Not connected", "Not connected to Quality Center" End If If mybug.Status="Open" Then BugId=mybug.DefectId MsgBox BugId End If 'OR**********************************--------------------- -----********************************** If Bug_Fields("BG_STATUS").Value ="Open" Or "Re Open"Then BugId=Bug_Fields("BG_BUG_ID").Value MsgBox BugId End If
