Search results

  1. S

    Filter Excel Data By Specific Criteria

    Is it possible to filter to values, which is not in my list. So that I have an array of values, but I want to filter to those values, which are not in this array - to EXCLUDE these values. I tried to do in this way array("<>1", "<>2", ... "<>n"), but it throws an error. Is there some other...
  2. S

    Manipulating large volume of Excel data in Blue Prism

    Actually, you were right. I've gone through my code and I noticed that my vlookup consisted of semicolons ";" because I just copied formula from excel and there it was written through semicolon. But in Code it is important to use comma "," Anyway, thanks for your contribution!
  3. S

    Manipulating large volume of Excel data in Blue Prism

    I tried to use for simple formulas, for instance to insert to cell C2 value "=A2=B2" and it worked. Also, I tried "=Sheet1!A2", and it worked too. But for lookup it didn't. I'm assuming that these is because of the difference in number rows. But I don't know exactly the root of the problem
  4. S

    Manipulating large volume of Excel data in Blue Prism

    Message: Exception from HRESULT: 0x800A03EC
  5. S

    Manipulating large volume of Excel data in Blue Prism

    Hi, I've done everything according to Approach #2 and your algorithm works. However, for vlookup i'm getting an exception with message: "0x800A03EC". I tried to use different formulas. For instance, I used SUM function and it worked well, but for vlookup i'm getting an error. Don't you know...
  6. S

    Filter Excel Data By Specific Criteria

    Ok, I understood. Thank you But, when I want to use more than 2 criterias, I'm getting an error. My code looks following: sheet.range(varUsedRange).AutoFilter (Field:=14, Criteria1:=0, Criteria2:=11, Criteria3:=25, Operator:=2) Also, I tried to put Operator between criterias and I'm still...
  7. S

    Filter Excel Data By Specific Criteria

    Hi, I am trying to implement multiple filters with multiple criterias. For multiple critierias I want to use Operator:=xlAnd However, I'm getting compiler error that xlAnd is not declared. Where should I declare this operator. I'm writing code inside of Excel VBO
  8. S

    Blue Prism

    Blue Prism
  9. S

    Process studio and Object studio difference in speed

    I have noticed that when I execute some flow in Object studio, it will be slower than if I publish this Object and execute it in Process Studio. Can somebody explain what is the reason for this? Thanks
  10. S

    is there some way to Read PDF through OCR without launching it?

    Is it possible to run reading PDF file on different virtual machine, so that I will not see the whole process, and continue working on different application.
  11. S

    is there some way to Read PDF through OCR without launching it?

    I'm trying to read Image PDF (Not document). I have seen a lot of tutorials about reading Image PDF files using read text with OCR, but in all cases they are launching PDF files to read data or work with already opened PDF. However, I don't want to launch the PDF to read data.
Top