QTP - UFT - How to get used range in excel

                                          

Link to Mandatory QTP /UFT Interview Questions to read before Interview

Code:-
strFilePath = "C:\DelMelater\UserData.xlsx"
Set o1 = CreateObject("Excel.Application")
Set objworkbook = o1.Workbooks.Open(strFilePath)
Set objworksheet = objworkbook.Worksheets("Sheet1")

msgbox objworksheet.usedrange.rows.count
msgbox objworksheet.usedrange.columns.count
msgbox objworksheet.usedrange.Address

Set objworksheet = nothing
Set objworkbook = nothing
o1.Quit
Set o1 = nothing

' The First message box will give you used Rows Count
' The First message box will give you used columns Count
' The First message box will give you address of the last cell used like $F$8:$G$10

Link to Mandatory QTP /UFT Interview Questions to read before Interview

QTP - UFT - How to open a browser with google.com as url using VBSript

Link to Mandatory QTP /UFT Interview Questions to read before Interview

This question is some time confusing for on going interview guys.

How to open a browser with google.com as url using VBSript or How to open a browser with google.com using UFT or QTP.

Answer is simple


Syntax
Set o1= Createobject("InternetExplorer.Application")
o1.Visible = true
o1.Navigate "www.google.com"
Set o1 = nothing


Regards,
Sreenu Babu

Link to Mandatory QTP /UFT Interview Questions to read before Interview