Search results

  1. N

    Extract the Excel Data which is in color

    i agree both, however also you have to mention based on which column you want to filter that specific color
  2. N

    MAPIEX: Failed to access message store

    MAPI Ex VBO will use the outlook configuration from the system if the profile is available which you mention in Configure stage then only it will work or else no. With Office 365 will have lot of issue, it will ask prompt to enter credentials always and due to those issues we downgraded to...
  3. N

    Extract Start and End execution time

    Use the Get Item Data Action, it will have loaded, deffered, completion, exception date column from those column you can extract Min and Max Date Time to get the Start and end execution time for a process
  4. N

    Blue Prism Mapiex error - "Failure in Send Mail function of Blue Prism Extended MAPI Automation. Failed to access message store"

    if we are using MAPI Ex. Will get this exception if we have secondary profile setup in outlook in Office 2013 and Office 365 as when we open outlook with secondary profile then outlook should popup credential window for that profile. if we did not get credential popup for secondary profile in...
  5. N

    How to Set formula on filtered column(s)?

    directly use the VBA Code in Code stage to apply formula on excel sheet instead of using the Excel VBO actions
  6. N

    MAPIEX: Failed to access message store

    Sending an email with which VBO ? if you are using MAPI Ex then check sending an email manually from that profile which you have mention in Configure stage
  7. N

    Dropdown In Web Application

    if its not work then we have to check the site and have play to with the modes
  8. N

    Dropdown In Web Application

    Check the element type in application modeler for that element and select list or list item then you will see different option in navigate stage
  9. N

    Excel Get Worksheet as Collection gives different values as in the Excel

    when i am loading data into collection , i am getting as is in text format of TRUE or FALSE what i have in excel
  10. N

    Rpa blueprism

    check the HTML type is showing as Table or not, next check the attributes of the element which you have spied with which mode
  11. N

    Filed column doesn't exist error

    when ever you get this type of error message then re-import the Excel VBO you will be good to go...
  12. N

    Need a code to remove empty columns (similiar to removing empty rows)

    take a copy of "Remove Empty Rows" action page in "Utility - Collection Manipulation" VBO and rename to remove empty columns and in code tab clear all the code and enter attached code in it and run it...
  13. N

    Append excel with collection

    first get the number of rows from your existing file using the action "Get Number of Rows" from Excel VBO, next in "Write Collection" action input give the cell reference as "A" & the get number of rows output + 1 , next include column as False
  14. N

    How to Spy elements in google Chrome using BluePrism

    hey Patnaik, sorry for the delay in response. here is the link. https://chrome.google.com/webstore/detail/blue-prism-browser-extens/oaflhlmnamdgbgdgakpihkkdfapkebfp?hl=en-GB
  15. N

    Get Button State using Region Mode

    Dear All, i am working on Surface Automation for one of my project. currently i got struck in getting the button state (enabled/disabled). Issue is, before clicking on Ok Button on Windows application i want to know the button state whether it is enabled or disabled and based on this i have...
  16. N

    How to Spy elements in google Chrome using BluePrism

    If not found let me know I will share the link for direct download
  17. N

    How to Spy elements in google Chrome using BluePrism

    To work with chrome you have to install blueprism extension from Google extension then only you can able to spy the elements. Like to get the xpath or path u have to install selenium ide right like wise you have to install blueprism extension We already installed and it's working perfectly fine.
  18. N

    Pivot table data source

    The best answer I would recommend this. 1.create a dynamic range using offset nd counta formula in excel itself. 2. Create a define name using 1st step range. 3. In pivot table data source enter the define name. 4. Refresh the data that's it. In blue prism code stage , just add the code for...
  19. N

    read text data to excel (Need to convert excel data as "|")

    HI Raju, you can do directly this in excel itself, why you want to do in BP ?
  20. N

    How to send huge data in sql faster

    Hi, Sorry again, here is the code: i wrote a global function, how you can run this code is 1. in object -> In Initialise Tab -> Open the Rectangular box -> In Global code Tab write the attached screenshot code 2. add new page -> in code stage -> write this code : DataTable dtb =...
Top