Search results

  1. D

    INI Config File

    Introducing INI config file reader Returns Collection with sections defined in the file. I created this because I was sick of using Excel files for configurations. This tool is by no means perfect, but it works well with a simple structure. Example of INI config file: name = "Project1" version...
  2. D

    how to take screen shot in blue prism without using exception stage

    I use this one made in vb Dim area As Rectangle Dim capture As System.Drawing.Bitmap Dim graph As Graphics area = My.Computer.Screen.Bounds capture = New System.Drawing.Bitmap(area.Width, area.Height, System.Drawing.Imaging.PixelFormat.Format32bppArgb) graph = Graphics.FromImage(capture)...
  3. D

    Downloading Outlook Attachment Files

    I just save all the attachments to the folder, get files with utility object and delete all except ones with extension "*.xxx" (that i need)
  4. D

    Issue in closing SAP Application

    Did you check in the task manager if the sap process is really running? Same happens to me that I can see on the screenshot. But for me it's just icons that disappear when i hover mouse over it and oc there are no sap processes opened. It's just a visual thing window didn't solve. If you...
  5. D

    MS Excel VBO Issue

    There could be many reasons for this error. Office installation could be incomplete or on trial. Excel could be still working when you try to save it. There could be a "popup" with something. I'd suggest you trying to google the error detail message and try finding the reason why it's happening.
  6. D

    Want to copy Text from browser to MS word

    I made a template word file - for example .: "Dear *name*, with your id number *idnum* we ....". Then I searched for *name*, selected it and wrote over it.
  7. D

    Solved How can i identify 1 day of month is Saturday / Sunday??

    You could use the calc stage.. example: FormatDate(Now(); "dddd") (=tuesday)
  8. D

    Help on Comparing Dates

    I've just posted reply in another post! Here: https://www.rpaforum.net/threads/calculate-the-week-number.12710/#post-25777
  9. D

    How to check for duplicate rows in a column

    How about this: Number position of rows Filter collection to another coll as unique(remove duplicates) Loop this unique collection line by line filter collection value and get rows with same value flag the rows where duplicates are (filtered collecion has >1 rows)
  10. D

    Calculate the week number

    Almost! DateDiff(1; ToDate("1.1." & FormatDate(Today(); "yyyy")); AddDays([Date];-1))+1 This is what I made up. [Date] is date you wanna compare it to.
  11. D

    Get/read all drop down values of cell in excel to collection

    From the top of my head: Get collection of a column (A:A) Delete duplicate items
  12. D

    Unable to double click on an element!

    It really depends on where do you need to double click. I have solution where i send two single click shortly after each other. In another one i had to read bounds and click on a specific pixel coordinates, because app didn't allow it otherwise.
  13. D

    Couldn't identify foreground window (SAP) after closing Adobe Reader

    Update: After few hours of trying to make it work I switched to FIREFOX - with adobe plugin. Works like a charm.
  14. D

    Couldn't identify foreground window (SAP) after closing Adobe Reader

    Hello, I'm facing a problem with BP not being able to detect foreground window after closing Adobe Reader DC (i use it to auto print docs). I'm using SAP to open an attachment (it opens in adobe reader), where i attach to it, print and close it. After closing it it does not switch to (last)...
  15. D

    Identifying An Upload Browse File Prompt

    This could be problem with parameters as you captured the field in application modeller - extra parameter that's not needed or it could be problem when attaching to the window - child item (attach page in object could be 1, not default 0) -- this is problem with IE settings (which i once...
  16. D

    Delete Rows in Collection

    If the header is always the same.. I would use Filter Collection, that would look something like that would extract one row (which has value "Total"), from which i might be able to extract values i need. I'm not sure this would help your case.
  17. D

    How to copy only one column from a collection using BP?

    I just want to add a note to the column extraction -- there is an action in collection manipulation called extract columns into Collection which does it without looping.
  18. D

    Collection Manipulation - Filter

    Filter doesn't work with dots or spaces. I made a new object just for working with spaces and dots, but it's quite complicated. Try looping it to find the string you're looking for, or replace it with calc (and assign back to collection) if you want to get rid of spaces.
  19. D

    To check if a value is a text

    You could also regex to check - "([A-z]+)" for text (you would neet to add any special character to the list, if you want to check for them too), or "([0-9]+)" for number
  20. D

    Need to check collection empty or not

    I've always done it with count rows and if 0 then is empty. You could duplicate count rows action in VBObject and make it return FLAG...
Top