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 |
How you are maintaining shared object repository in your team or your project?help me plz
suppose the given string str = {"vamsikrishna%%&%*&**"} count the no of vowels and special characters are repeated
How to covert a String to an integer?
Can anyone please tell me how to select next 5th business date from calendar using QTP/UFT ?
1 Answers Cigniti Technologies,
Difference between test object and run time object?
what is meant by keyword driven frame work can any one answer plzzzzzzzzzzz
If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?
what is the long form of QTP ?
We stored into the objects OR and then write the scripting
In a webpage how to check the dynamic links that re changing regularly?( without using regular expressions.)
how to load all resource files(function libraries,object repositories etc) into tests without associating them?
Shared Object Repository is preferable while dealing with dynamic objects ok? descriptive prog also same? ok but why descriptive?(only for w/o application)