Activate Window

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

[forumsupport]

Hello Clay,

Insert enough delay after the command to execute the command flawlessly. Also, specify actual window title (without wild card) in Activate Window command as you are working with multiple excel files.

Can you upload the text format of your task so that we can look into it and suggest a viable solution? Open your task in a Task Editor, go to Tools->Save as text file and upload this text file.

[Clay]

Hello,
Thank you for the suggestion. I have added a time delay after telling AA to activate a certain window. I will know tomorrow if the task runs successfully or not.
I have attached the .txt file if you have any other suggestions.

Thank you!!

[forumsupport]

Hello Clay,

We looked into the text format of your task. We suggest you to use Excel command to work with multiple excel files. That way the actions will be performed in specified worksheet only irrespective of the active window and your task will run faster. You can specify a different session name while opening each spreadsheet. Each time you use the ‘Open-Spreadsheet’ command, it starts a session named ‘Default’ and that will continue to run unless you ended the session using the ‘Close Spreadsheet’ command or close the spreadsheet manually. All the commands between ‘Open-Spreadsheet’ and Close Spreadsheet’ are dependant on the session which is started using the ‘Open Spreadsheet’ command.

You can view demo on Excel commands usage from, Excel Automation Software - Automate Excel functions with Automation Anywhere

[Clay]

Thank you for the suggestion.

However as I stated in a previouse post I am unable to use the built in commans for Excel due to needing access to use paste special options. When using the built in Excel options it does not allow me to have access to the same paste special options.

Any other suggestions?

Thank you,

[forumsupport]

Hello,

You can create an excel macro for paste special and call that macro from Automation Anywhere using Excel:Run Excel Macro command.

We have attached a sample task for your reference. To run this task,

. Please copy .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Please copy Book1.xls under C:\

Hope that helps.

[Clay]

Thank you, that worked great!!