[Clay]

I have a job where I am using the command Activate Window so the task can open a window that is already open in the task bar.

When I run the task manually it usually find the window, other times it does not find the window and this causes the job to fail.

The window I am trying to activate is an excel sheet, due to the way I am using past special I have found that using the command for Excel to activate the window does not work. Rather it will not allow me to paste special only values into another worksheet, Excel 2007

I also have more than 1 Excel sheet open at the time I am trying to activate the window.

Do you have any suggestions?