Task Office - Office macro

Top  Previous  Next

The Office macro Task is able to execute macros located in Excel, PowerPoint, Access or Word. You are also able to specify parameters for the functions and their value types.

 

clip0155

 

Credentials

You must specify a Credential, a remote server name, user name and pass word for a user on the remote server which the command will execute as. Click on the Manage credentials button to add a new Credential.

 

File type

Select either Excel, PowerPoint, Access or Word.

 

File path

This is the full path to the document.

 

Parameters

If a macro function needs parameters you can specify them here by clicking Add.

 

clip0156

 

Choose appropriate value type and set the actual value. Normally VisualCron validates the value against the data type. If you use a Variable that validation can fail if the value is not set in the Variable. To prevent failure you can uncheck the Validate value checkbox.