Recent content by gil.silva

  1. G

    how to solve the difference between excel macro code and Excel VBO code in BP

    Hello, The best way to understand Excel VBO is to check the existent actions and apply the same functions/methods to the new ones. You can notice that Excel VBO has a huge Global Code in the Initialize page, which is huge to facilitate the creation of action. So, you have functions like...
  2. G

    How to download multi line attachment from a HTML Table

    Hello, I guess you're clicking in the table links to download the attachments, right? You can use a loop where you increment the table html reference to click in each row/link.
  3. G

    change a value of an element in XML with Blue Prism

    You can use Regex to find and replace the value or you can use the Utility - XML object provided by Blue Prism.
  4. G

    Finalizing the best approach

    1. Make that as a pre-requirement. The account should be manually configured in Production. 2. That logic should be stated in the process. Blue Prism Control Room is quite limited and it doesn't allow to easily build dynamic schedules. For your specific example, I would schedule the process to...
  5. G

    Renaming multiple file names in the data collection stored in Current values but not in the Initial Values.

    Hello tiger19, You can use a Loop stage, in the calculation stage you should have something like Left(CollectionName.Filename, Len(CollectionName.Filename)-13)
  6. G

    Warning status in control room

    So, it means the robot is getting stuck in some action, please through the process log, identify the stage where the warning is occurring and try to identify the issue. Feel free to post here a screenshot of the stage/error
  7. G

    Warning status in control room

    Warning status it doesn't necessarily mean that you need to restart the server. Sometimes, if the robot takes a long time in a specific stage (calculating something in Excel, for example), it will show a warning status in Control Room.
  8. G

    Matching format of number

    You have two approaches: Use Regular Expressions (RegEx) Use the functions for Text manipulation 1. Regex expression: 1\d{3} | P\s{4-5} | \d{5-6} 2. Functions to manipulate text (Len([number]) = 4 AND StartsWith([number], "1") ) OR (Len([number]) = 5 OR Len([number]) = 5 AND...
  9. G

    Help merging 4 .csv files into one

    Hello, There are a couple of options to perform that: IF the CSV are quite small (less than 10k rows): Use Excel VBO: get worksheet as collection Use Utility - Collection Manipulation: Append Rows to Collection Repeat for all the 4 CSV files Write Collection to file (Excel VBO) IF the CSV are...
  10. G

    Excel VBA - Copy Paste As Values

    Dim sw, dw As Object Dim ss, ds As Object Dim excel, sheet, source, destination, cells, cell As Object Try sw = GetWorkbook(Handle, Source_Workbook) dw = GetWorkbook(Handle, Destination_Workbook) ss = GetWorksheet(Handle, Source_Workbook, Source_Worksheet) ds = GetWorksheet(Handle...
  11. G

    Find value from collection in Email Body

    Can you describe the problem? Your approach seems correct, you just need to insert a Loop with the calculation stage inside and a decision stage to know if the output is True/False
  12. G

    Saving Excel as PDF

    Hello, Duplicate one action from the Excel VBO, for instance, the Rename worksheet. Keep the initialize of variables and ws and add: ws.ExportAsFixedFormat(0, Destination) Destination should be your input variable with the path + filename.pdf
  13. G

    Copy Collection

    Hello kiss4344, Keep in mind that when you use Copy Rows, the 'start row' is the index, which starts in 0. "Start Row must not point beyond the end of the collection. " It looks you're trying to copy from an index out of the collection range (e.g collection with 10 rows, index from 0 to 9)
  14. G

    Blue Prism

    Hello, How are you attaching the collection in the e-mail? There are 2 main ways to report/send table data in an e-mail: Write Collection in an excel file and attach it Loop the collection and concatenate the data in a Calculation stage, then write it as Body, for better result use HTML format...
  15. G

    Queue Management, Schedule and Environement variable: how to keep clean when going big.

    Hello DFugere, Congrats on your team achievements. There's a couple of best practices/tips which can be followed to have a clean/organized environment: Naming convention: using naming convention can make a huge impact to properly maintain big environments, this approach should be used in the...
Top