Open Excel and take screen shot of filtered record


To automate a business process, I need to open an excel file and take screen shot of filtered record. I am able to open the excel but not able to filter the record and take Screen shot.

This is my excel:

and I want SS of this


I tried desktop and basic recording but it’s getting hanged while recording.

Pls suggest how to do this.

Hi @p4uk80,

I don’t think filtering the excel work with screen recording, better to write a piece of VB code to filter and send hot keys to take screenshot.

If you don’t want to use any code, try filter data table and write it in a new sheet and then take screenshot

refer this post… may it help u