topic RE: Hresult:0x800 in Product Forum

Hresult:0x800

delacoche — Thu, 17 Feb 2022 09:54:00 GMT

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
------------------------------

RE: Hresult:0x800

PabloSarabia — Thu, 17 Feb 2022 11:44:00 GMT

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
------------------------------

RE: Hresult:0x800

Rambo27 — Thu, 17 Feb 2022 11:50:00 GMT

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
------------------------------

RE: Hresult:0x800

michaeloneil — Thu, 17 Feb 2022 14:05:00 GMT

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
------------------------------

RE: Hresult:0x800

delacoche — Thu, 17 Feb 2022 14:24:00 GMT

this is my code

RE: Hresult:0x800

delacoche — Thu, 17 Feb 2022 15:45:00 GMT

can i have a picture of your code please?

thx

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

RE: Hresult:0x800

Rambo27 — Thu, 17 Feb 2022 16:08:00 GMT

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
------------------------------

RE: Hresult:0x800

michaeloneil — Thu, 17 Feb 2022 18:14:00 GMT

Hi

Cissoko please see the screenshots below. Hope this helps

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