QTP not recognising macro

[mayuri]

Hi, I want to automate a macro excel
But QTP could not record a single operation done on Macro.
Give solution for same

Activities to be performed on Macro excel:
Selecting a drop down
Clicking a button
fetching data
etc etc

Thanks in advance

[RitaG]

Hi Mayuri,

I have come to this forum with a similar problem. Where you able to find a solution for this ???

Any help would be highly appreciated.
Thanks..

[krr]

Mayuri and Rita,

Instead of recording if you want to Run a macro you need to work with Excel Object. For Example it goes like this:

Code:

set ex=CreateObject("Excel.Application")
set wb=ex.Workbooks.add
set ws=wb.Sheets("Sheet1")
wb.RunAutoMacro ''''what ever the macro you want to Run which is inbuilt.

Also there are other methods to work with like:
UpdateLinks
Openlinks
Setlinksondata
so on and so far


Try this and let me know if it works.

[RitaG]

Krr,

we can use "wb.RunAutoMacro" to run the macro.
But how to perform an operation like Selecting an item from a drop down list on the sheet?