QTP not recognising macro - Printable Version

QTP not recognising macro - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: QTP not recognising macro (/Thread-QTP-not-recognising-macro)

QTP not recognising macro - mayuri - 02-04-2012

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

RE: QTP not recognising macro - RitaG - 09-27-2012

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

RE: QTP not recognising macro - krr - 10-03-2012

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.

RE: QTP not recognising macro - RitaG - 10-04-2012

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?