Marcos(Excel sheet)

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