I have a test case where I need to copy data in excel file into another excel sheet. Later, I need to click on the button inside the excel sheet. This button is not provided by excel but created by engineer with function.
Please help me on how to object spy that button in order for me to be able to click on it when I open the excel during running time. Or if you have any suggestion of what should I be doing, please help…
I tried using Spy Window Object, but it seems an error occured :
Below is the screenshot of the button that I mentioned in above :
If I click on it , the data will be generated from column A to N