Marcos(Excel sheet)

[qtp1983]

I have an issue regarding selecting the button in marcos (Excel sheet) in QTP and am not able record the clicking button operation in excel sheet.

[adityaaggarwal]

In VBA In the module add the macro as

Code:

Sub button1_click ()
-----------
-------
End Sub

and then right click on the button and assign the macro to the button.

Try and tell if it works.

[qtp1983]

Please vill u explain in clear words.
iam not getting the above code..


Thanxs.

[Ankur]

Can you explain your question clearly and in detail? I hope you are talking about macros and not 'marcos'

[qtp1983]

Can you explain your question clearly and in detail? I hope you are talking about macros and not 'marcos'

Right, Iam talking about Macros only.
In Macros i have few worksheets able insert data using this script.
Example:

Code:

Set obj=getobject(Excel.Application)
obj.worksheets("INPUT").range("bot").value="3"

by using this script able to insert the data in a particular sheet.
After inserting the data value i want clicking a button in that sheet only.
Here am getting any idea how to click a particular button in the following worksheet.

Please can u help me.

Thanks.

---

Right, Iam talking about Macros only.
In Macros i have few worksheets able insert data using this script.
Example:

Code:

Set obj=getobject(Excel.Application)
obj.worksheets("INPUT").range("bot").value="3"

by using this script able to insert the data in a particular sheet.
After inserting the data value i want clicking a button in that sheet only.
Here am getting any idea how to click a particular button in the following worksheet.

Please can u help me.

Thanks.

---

[quote='Ankur' pid='5344' dateline='1240045012']
Can you explain your question clearly and in detail? I hope you are talking about macros and not 'marcos'

Right, Iam talking about Macros only.
In Macros i have few worksheets able insert data using this script.
Example:

Code:

Set obj=getobject(Excel.Application)
obj.worksheets("INPUT").range("bot").value="3"

by using this script able to insert the data in a particular sheet.
After inserting the data value i want clicking a button in that sheet only.
Here am getting any idea how to click a particular button in the following worksheet.

Please can u help me.

Thanks.

[neelam]

You mean that you are able to record the macros but when you are clicking the button then click event is not getting recorded. is it so????

[qtp1983]

No, Iam not even record any of the operation in macros sheet ike insert data and clicking the button.