Pre-purchase question

[tompan]

Hi There,
I am looking to set up a menu of macro tasks to be completed across excel/access/word/outlook.

Can anyone tell me if there is a way of say setting up a list of macros that can be run from buttons in Excel to execute these tasks?

I want to make it as easy as possible for all users with low understanding of Macros to run these tasks from one location.

Regards,

Tom

[forumsupport]

Hello,

You can use Run Task command if you want to chain the tasks together. You can find this command under Tasks/Scripts command category.

You can call Automation Anywhere tasks from any another program or a script. For example

To call Automation Anywhere 'download-data.atmn' from an excel macro, add following text into any excel macro.

Dim RetVal
RetVal = Shell("C:\Program Files\Automation Anywhere\Automation Anywhere.exe "C:\Documents and Settings\<your username>\My Documents\Automation Anywhere\Automation Anywhere\My Tasks\download-emails.atmn" /u", 1)

If task is successful it returns 0 to the calling program or if it encounters any error it will return 1.

Note : All the tasks are stored under My Documents\Automation Anywhere\Automation Anywhere folder.

In addition, you can also run the task using hotkeys or keyboard shortcuts.
Using Hotkey property, just assign the keyboard shortcut of your choice and whenever you want to run the task just hit that keyboard shortcut. You can find hotkey tab under properties window at the bottom of screen.

Hope that helps.