Run macro from Access Button

[stichlynch]

Hi there,

How would I run my macro from with access by pressing a button on a form. I know how to create buttons but know nothing about VBA so I'd need this explain with a little detail.

Thanks for your help

Stephen

[forumsupport]

Hello,

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.

Hope that helps.