Want to get the name of current active worksheet in excel

Help
, ,
8

Awesome
Let me tell you how to do that
—use Start process activity and pass the file path of excel as input
—now this will open the file in foreground
—then use SEND HOT Key Activity and mention the key as alt+h without any selector chosen
—now use another send hot key activity with key o
(Not zero its o)
—and another send hot key activity with key as r
—then a final send hot key with key as ctrl+c

—now use a GET FROM CLIPBOARD activity and get the output from clipboard with a string variable named str_input

Cheers @AryanSingh

4 Likes