I need to click click "New Web Query" of Excel which is present under Import Excel Data under Data Tab using QTP.
Now problem is i am able to open New web Query page but QTP doesnt move ahead of below pasted line and status is RUNNING for QTP until unless i dont close the web Query page of Excel.
objExcel.CommandBars("Worksheet Menu Bar").Controls("Data").Controls("Import External Data").Controls("New Web Query...").execute
Could u please guide me how to handle this as after opening Web Query page i need to insert url in the text field of Web query.
I am not sure if you recording against excel, that is the not right approach.
Look at using VBA.
Below is the code generated using macros to Enter the URL and import the data, the same has to be customized to work with VBA and QTP, note many of the options in the sample code below may not be required.