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
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..
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.
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?