How to use excel macro

[Saket]

You can use this function in your Excel Module to Launch QTP

Code:

Sub LaunchQTP()
    Dim qtApp
    Dim qtTest
    
    Set qtApp = CreateObject("QuickTest.Application")  ' Create the Application object
    qtApp.Launch ' Start QuickTest
    qtApp.Visible = True 'Make the QuickTest application visible
End Sub

I am wondering why anyone would like to do this from excel? can you please explain your scenario where you need to do this?