Search results

  1. S

    multi sorting excel

    I dont think there is a need to create macro to sort a collection as we already have sort action in collection.. I am looking for vba to multi sort the columns in excel. Can you help me with that
  2. S

    multi sorting excel

    I cannot use collection, I need to do this in excel only.
  3. S

    multi sorting excel

    hi, can someone pls help with multi-sorting in excel. for example: there are 10 columns in excel and col H, I , B, C, D, E needs to be sorted all at a time in ascending order (like first 5 in A-Z and last one in 0-9). So, how to do that? thanks
  4. S

    Solved How to use the 'Extract Regex Values' action of Utility - Strings

    can you please help me with regex for this pattern: 123-456-7789 This particular string (10 digit number separated by -) can appear anywhere in a collection row like: <some text> <tab> 123-262-9282, APR15-MAY15. I used : (?<Name>\d{3}-\d{3}-\d{4}) but this does not works.
  5. S

    paste special values

    hi, how to keep the data in excel and removing formula. Example: there is a formula in cell range: P6:P15 and now i want to keep only data removing formula. I tried by using select > copy > paste but its giving me error: Ambiguous match found, even if there is a different data in all the cells...
  6. S

    [Blueprism] Code stage to paste data as values in excel

    I tried first solution but getting error: could not execute code stage: Ambiguous match found. I have duplicate values in that range, but that is requirement. How to fix it?
  7. S

    what is format cell in MS excel vbo

    Any suggestions on this would be highly appreciated.
  8. S

    remove duplicate rows

    Thank you, I will try this. If this column list is dynamic, for example, in one process I have to just two columns and next time there can be 3, 4 also. So how this can be set dynamic
  9. S

    remove duplicate rows

    hello, how to delete duplicate rows from excel based on duplicate data in multiple columns. example: col1 col2 col3 col4 val1 val2 val3 val4 val1 val2 val3 val5 val5 val7 val8 val9 so as per above example, bot needs to look for the duplicates in col2 and col3 data only and in result, it should...
  10. S

    mainframe automation

    hi, i am new to mainframe automation and using blue zone session manager. I am unsure about the application type to use in application modeller, also what should i put in session file path. I see foll. in app modeller. thanks
  11. S

    cell color based on value

    I have more than 6K records. And I am not using collection. I need to directly do that in excel.
  12. S

    environment locking and multi-bot

    No, in WQ I have to add sample 1 and sample 2 file data as that is my main file which needs to be processed. The sample 1 and 2 files are being prepared from dashboard file
  13. S

    Solved Run Time Error Macro freezes BluePrism

    You can create a separate object to handle that pop-up. I too faced similar issue, please check this thread for solution - http://rpaforum.net/threads/issue-while-running-macro.14133/#post-29759
  14. S

    cell color based on value

    Also how can I pass the operator as user defined.. because in some condition, it is =, <> or >
  15. S

    Excel related query

    Thanks Sahil. Can you also please help with this query: http://rpaforum.net/threads/cell-color-based-on-value.14148/#post-29787
  16. S

    cell color based on value

    hi, how to highlight the excel cells based on value present in another column or same column. Example- cola colb 25-Aug b 26-Aug c 27-Aug d 28-Aug e 29-Aug y 1. To highlight col b cells where col b does not contains text "d". So, rest all in col b to be...
  17. S

    Excel related query

    hi, can someone please help with below query: i have an excel file containing large amount of data like 6K, 7K. In that, there is a column of phone number (Col B). Now the requirement is to check if there is a duplicate entry for phone number, then col C needs to be updated with notes...
  18. S

    environment locking and multi-bot

    hi, can anyone pls help me in implementing environment locking /multi-bot feature: 1. there are three files, one is dashboard file and another is sample1.xlsx and sample2.xlsx files. 2. Bot is pasting the data from dashboard file to both sample 1 and sample 2 files and then some excel...
  19. S

    Issue while running macro

    Thanks, it worked.
  20. S

    Issue while running macro

    Hi, Can anyone please help with below issue: I am running a macro in excel but there is a pop up appearing in which there is a button "done", once the macro has run. I created a separate object to handle that pop up, but issue is bot is not moving further from Run macro stage so I am not able...
Top