Blueprism To Create Validation Drop Down List In Excel

[mcandrewe]

I have a Code stage running the following:
GetInstance(handle).Activecell.Validation.Add (Type:=xlValidateList, AlertStyle:=xlValidAlertStop,Formula1:=("Yes,No"))

This is producing the following error:
Page: Input Validation List Stage: Input Validation List Type: Error Action: Validate Description: Compiler error at line 1: 'xlValidateList' is not declared. It may be inaccessible due to its protection level. Page: Input Validation List Stage: Input Validation List Type: Error Action: Validate Description: Compiler error at line 1: 'xlValidAlertStop' is not declared

Anyone know how to resolve this?

 

[tomahawk1]

You have to replace Excel constants with their real value as they are not loaded (declared) in Blue Prism:

Type:=3, AlertStyle:=1

 

[mcandrewe]

You have to replace Excel constants with their real value as they are not loaded (declared) in Blue Prism:

Type:=3, AlertStyle:=1

Excellent thanks a lot for your help