excel macro to open QTP from excel

[karthik1979_us]

Hi,

Could anyone please provide an excel macro example which illustrates opening QTP through excel

Thanks,
Karthik

[geethwind]

Paste the below code in the Excel Macro and this should solve your purpose.

Code:

Sub QTPInvoke()
Set qtApp = CreateObject("QuickTest.Application") ' Create the Application object

qtApp.Launch ' Start QuickTest
qtApp.Visible = True ' Make the QuickTest application visible

End Sub