Hresult:0x800

[delacoche]

Hi , i'm new in blueprism please help me.
i'm writing my code filter excel , but i have a erro :
internql impossible d'executer la phase de code parceque l'exception a été lancée par la phase de code exception HRESULT : 0x800A03ECbut i think i have not erro in my code

------------------------------
cissoko yann
------------------------------

[PabloSarabia]

Hi Cissoko,

Can you share with us your code?

And... you have many options to interact with an Excel File. Are you considering using it instead of writing your own code?



Bye 🙂

------------------------------
Pablo Sarabia
Architect
Altamira Assets Management
Madrid
634726270
------------------------------

[Rambo27]

Hello @cissoko yann,

Please do check the handle which you are using while using the inside the code filter . It seems  the issue of the handle passing is different  you can use same page to create the handle and use in our code block for filtering excel. 

For filter excel you can also use VBO Collection Manipulation if that is what you needed for your use case where no need of code stage required.

if the column name is two separate words then it need to be in square brackets, i.e. [Left column]
also; when using variables its important to know the following; (its for text but you can experiment with it)
"[Column Name] = "'&[Variable]&"'"
""&&[Variable column name]&" = 'text'" or 
""&&[Variable column name]&" = '"&[Variable]&"'"
you can also swap out = for, <> or Like etc.

experiment with it, it will be slightly different with numbers only.

------------------------------
Shikhar Mishra
RPA Lead
Infosys Pvt Ltd
Pune,India
------------------------------

[michaeloneil]

Hi

Are you trying to set a filter on an excel file? Is this a code action you have written yourself and are getting an error message? If you share your code we could possibly identify errors in it. I've previously done something similar I've included my code below and hopefully its useful to you and you can make use of it or it will help you resolve the issue in your own code.

Inputs - Handle, range, workbookname, worksheetname, criteriastring, columnumber
Outputs - Success, Message

Dim ws as Object, strList as Object

ws = GetWorksheet(handle, workbookname, worksheetname)

Try

If (criteriastring<>"") Then

strList = Split(criteriastring,",",-1)

ws.Range(range).AutoFilter(Field:=columnnumber, Criteria1:= strList, Operator:=7)

success = True

Else 

success = False

message = "CriteriaString should not be blank"

End If

Catch ex as exception

success = False

message = ex.Message

End Try

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

[delacoche]

this is my code

[delacoche]

can i have a picture of your code please?

thx

------------------------------
cissoko yann
------------------------------

[Rambo27]

In third Screen shot , I cant see you initialize the handle when you are using Apply filter action. 

Please check once by passing it

------------------------------
Shikhar Mishra
RPA Lead
Infosys Pvt Ltd
Pune,India
------------------------------

[michaeloneil · Accepted solution]

Hi

Cissoko please see the screenshots below. Hope this helps





------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------