Marcos(Excel sheet) - Printable Version

Marcos(Excel sheet) - 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: UFT / QTP Regular Expressions (https://www.learnqtp.com/forums/Forum-UFT-QTP-Regular-Expressions)
+--- Thread: Marcos(Excel sheet) (/Thread-Marcos-Excel-sheet)

Marcos(Excel sheet) - qtp1983 - 04-16-2009

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.

RE: Marcos(Excel sheet) - adityaaggarwal - 04-17-2009

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.

RE: Marcos(Excel sheet) - qtp1983 - 04-17-2009

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

Thanxs.

RE: Marcos(Excel sheet) - Ankur - 04-18-2009

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

RE: Marcos(Excel sheet) - qtp1983 - 04-18-2009

(04-18-2009, 02:26 PM)Ankur Wrote: 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"

(04-18-2009, 08:53 PM)qtp1983 Wrote: [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"

RE: Marcos(Excel sheet) - neelam - 04-20-2009

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

RE: Marcos(Excel sheet) - qtp1983 - 04-20-2009

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