Search results

Hi, How can we get the time difference in hours excluding weekends? Thanks.

Any suggestions on this would be highly appreciated.

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

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...

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

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

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

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

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

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

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...

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...

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...

Thanks, it worked.

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...

How exactly you did that? I too have similar requirement, can you please share the detailed steps on how can I run the VB script. What did you write in that

Hello, I have a similar requirement, where I need to sort the data based on multiple columns all at a same time: Col A Values <smallest to largest> AND/OR Col B Values <smallest to largest> AND/OR Col C values <A-Z> . How to achieve this?? I cannot use macro because this excel is being...

Also there is no space after email address text and <some more text here>. Its in continuation

hi, how to get the email ID which is written in additional contact info: First name: <some text>,Last name:<some text>,Telephone number: <some text>,email:<some text>First name: <some text>,Last name:<some text>,Telephone number: <some text>,email:<some text>First name: <some text>,Last...

No, date conversion is done