Search results

  1. P

    Use of config files

    Hi, Could anyone please let me know what are the advantages of using config files over environment variables? Background : We have 30+ processes running in the PROD env. and there are more to come. The list of env. variables is really long and is going to grow longer. Hence, thought of using...
  2. P

    Intersection of Collection Data

    Hi, I have two collections with same columns in both of them. The only difference is the first one will have more data than the second one. My purpose is to get the uncommon data from both the collections and copying them to a new pre-defined collection. I do not want to loop through...
  3. P

    Open PowerBI from Blue Prism

    Hi, I need to open PowerBI from Blue Prism and then carry out some operations within PowerBI,. Is it possible to do it using BP? Any suggestions/help much appreciated. Thanks.
  4. P

    Memory usage in BluePrism

    Hi, Could you please advise me if using the global variables/data items in BluePrism consumes more memory or the data items created locally and then being passed onto the other pages? Thanks in advance.
  5. P

    Better Programming Practice

    Hi, I'm just wondering if it is a better programming practice to navigate to multiple pages from a page (not just the main page) to carry out a task? What are the advantages and disadvantages? Could anyone please enlighten me on this? Thanks in advance.
  6. P

    Move a folder (with several files in it) from one location to the other

    Hi, How do I move a folder with files from one location to the other? It is basically windows cut and paste. Couldn't find any thing in File Management VBO or not sure if I'm missing some thing. Is there anything readily available to carry out the task? Thanks..
  7. P

    Excel Add-Ins disappearing when opened from Blue Prism

    Hi, I'm facing a problem where the Analysis Toolpak add-in in Excel disappears when it is opened from Blue Prism. It works perfectly fine when opened from manually. Please give a solution to resolve this issue. Thanks
  8. P

    Running Excel procedure from Blue Prism

    Hi, I need to run an excel macro with parameters. To achieve this, I wrote a procedure in the Excel module that can accept parameters but, couldn't find it in the macro run dialog box at all. To overcome this, I moved this procedure to the sheet code area and called this from worksheet_change...
  9. P

    Weekday Function

    Hi, Is there any function available in Blue Prism that is equivalent to Weekday? If not, any idea how to achieve this? Basically, I'm trying to find the date for the last Friday in a month. But, to in order to generalise it more so that it would find any weekday in a month, I'll be passing the...
  10. P

    Automating Outlook

    Hi, I have process to design in BluePrism in which I need to copy data from some of the columns of an Excel file, paste them onto the Email Body section in MS Outlook and then apply some formatting like clicking on the design tab, selecting the table layout for the data, etc. Could anyone...
  11. P

    Using Data Validation in Excel Using BluePrism Code Stage

    Hi, I need to use the data validation in Excel. It is like inserting a list of values in cells of Excel in the form of dropdown/list. Could someone help me with that please?
  12. P

    Excel Queries

    Hi, How do I refer to a workbook that is already open and change the cell color using code stage in BluePrism? Thanks
  13. P

    Get Month Name from date

    Hi, Is there any direct function available in blueprism to get the month name from given date? Thanks
  14. P

    Run Process on VDI

    Hi, I've a Blue Prism process which works perfectly fine on the machine is open. But, if I try to run the process on the remote desktop, the robot fails to identify the SAP application that has been launched just before that. Did anyone have the same problem like this or any idea about how to...
  15. P

    Excel Manipulations

    Hi, I need to use Blue Prism to do some manipulations in an Excel file like copying, filtering and writing the data, using the formulas, etc. which I hadn't tried before. As a first step to start with I used the code stage with the following code...
Top