how to open Excel sheet & write in it & save it?
Answer / guest
Set excel = CreateObject ("EXCEL.Application")
excel.Caption = "Test Caption"
excel.Visible = True
Set doc = excel.Workbooks.Add()
Set selection = excel.Selection
With selection
.Cells(1,1).Value = "Test value"
End With
doc.SaveAs("E:\Excel.xls")
excel.Quit
| Is This Answer Correct ? | 10 Yes | 1 No |
write a script to verify the image path(src property) of the images which are in web pages.
for example one window is there, the window contains how many edit box's i want script? i know the script but that is not exact answer.... The script is like this .......... set a=description.creation() a("Native class")="WinEdit" b=window("Flight Reservation").childobject(a).count msgbox b if u found exact answer please getback to me? raju.ippali@gmail.com 9823257761
Did QTP prove efficient for your project? Yes or No, explain?
if mandatory and Assitive propertys are shows same how will u write skript in QTP window
How to export(copy) the entire webtable from the webpage into Excelsheet? using Vb scripting
write is the code for regular expression in QTP
what is the extension for the test version of the script?
How does QTP identifies the object in the application?
Hi i have a webtable which is having 7 columns and 6 rows of data in that table of 4th and 5 th column each row is partiotioned into 3 sub rows i want to verify in each partitioned rows of corresponding row for ex values will be like this 0 / 1 ,26/28.if it is 0/1 i want to skip only if any num/num greater than 1 i want to click.
Presently i am working on QTP 8.2 Version,i want to know features in 9.2 version, because i have not sufficient time to put the effort on the 9.2 version
how to handle the textboxes where in it should take the sum like ex:: while posting a question in this site it will for what is the result of 6+3=__ where in we have to enter manually 9 and click on submit... but how to handle these cases in qtp.. can someone plz help me out wid dis...
Hi I am from delhi, Now I can surely say that no institution of QTP here in Delhi After reading you people I want to get cry, from last six month I am trying to learn QTP, I have knowledge too but dont know VB Script. Now it appears that without learning QTP no one can learn complete QTP, I want to get a formal learning in QTP. Can you suggest me the best institution. and please let me know the charges and span of the course too. thanks in advance to you alkaa.dugaal@gmail.com